Supply chain | Supply Chain Management, Commerce

Table Browser Security Problem

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Suggested answer

André Arnaud de Cal... 294,931 Super User 2025 Season 1 on at

Like (0)

Report

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 on at

Like (0)

Report

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 101,158 Moderator on at

Like (0)

Report

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.