Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : wIt/hUgpnwIrvcdM+0Sgc7
Supply chain | Supply Chain Management, Commerce
Suggested answer

Table Browser Security Problem

Like (0) ShareShare
ReportReport
Posted on 8 Jan 2020 11:48:11 by

Hi

We have created roles within D365 and they have been assigned to users and are working well.

In addition, we'd like to grant some power users access to browse the underlying tables to which they have access using the appropriate link - example below:

https://[ENVIRONMENT NAME]/?mi=SysTableBrowser&TableName=SalesTable&cmp=[COMPANY NAME]&lng=en-us&limitednav=true

Rather than extend the 'Sales order creation' role we've created, for example, I'd like to create a new 'Table browser' role, and assign that to each of the power users.

I created the role and assigned the 'Open table browser' privilege to the new role.  I then assigned the table browser to a user with the sales order creation role, but they were unable to browse the table and got an error when entering the link in their browser:

"You are unable to navigate directly to this menu item systablebrowser".

I have tried adding the new table browser role to other users with wider access but still get the same problem.

The only users that appear to be able to use the table browser link appear to be those with System Administrator role.

Has any one else experienced this problem or can someone confirm that it is only System Administrator users that are able to use the table browser link?

Thanks

Mike

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    292,978 Super User 2025 Season 1 on 08 Jan 2020 at 21:57:28
    RE: Table Browser Security Problem

    Hi mpsavage.uk,

    As there is no menu item for the table browser in any menu, you will get this error. When there is no menu item found in the menu, then the error will be shown to non system administrator users. As the system administrator will bypass all security, this role is the only one allowed to start menu items which are not in the main menu.

    Not sure why a normal user should have access to the table browser. If you want to have it, then you can extend a menu to add the menu item. Then you need to test if the power users are also not able to access data which are not allowed for them. I don't think there will be an issue, but test the most important/sensitive tables.

  • Community Member Profile Picture
    on 08 Jan 2020 at 13:03:02
    RE: Table Browser Security Problem

    Thanks Nikolaos, as I thought, but was hoping that wouldn't be the case. I would have expected the privilege to allow users to only browse tables for which they have access, but sadly not.  Let's see if anyone else has a different experience, but it doesn't sound hopeful.

  • Suggested answer
    nmaenpaa Profile Picture
    101,156 Moderator on 08 Jan 2020 at 12:46:39
    RE: Table Browser Security Problem

    As far as I know, only system administrators can use the table browser. I don't know why there is this separate privilege, but according to your results it doesn't seem to work. Even if it would work, that would mean that your users could read all tables in the system, which might not be what you want.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,978 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,821 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete