D365 Finance & Operations and Dynamics AX Forum

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).



------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA
------------------------------

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:


------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.



------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA
------------------------------

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Kerstin,

So I was able to get this to work by doing the following:

1) Creating a copy of the sysTableBrowser menu item display into a project
2) Changing the Allow Root Navigation parameter from No -> Yes

3) Create/assign this copied menu item to a privilege/role (here is an example)
4) When this is assigned to a user and they navigate to <RootD365FOEnv>/?mi=SysTableBrowserCopy&tableName=<tableName>&cmp=<companyId> they should see the table browser
(for example to see the UserInfo table: /?mi=SysTableBrowserCopy&tableName=UserInfo&cmp=DAT)


------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA
------------------------------

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Hi, Alex,

I am interested in doing this as well. Can you please tell me where that sysTableBrowser menu is? 

Thank you,
Polo

------------------------------
Polo Garcia
Maple Leaf Farms, Inc.
------------------------------

Original Message:
Sent: Feb 25, 2020 11:23 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

So I was able to get this to work by doing the following:

1) Creating a copy of the sysTableBrowser menu item display into a project
2) Changing the Allow Root Navigation parameter from No -> Yes

3) Create/assign this copied menu item to a privilege/role (here is an example)

4) When this is assigned to a user and they navigate to <RootD365FOEnv>/?mi=SysTableBrowserCopy&tableName=<tableName>&cmp=<companyId> they should see the table browser
(for example to see the UserInfo table: /?mi=SysTableBrowserCopy&tableName=UserInfo&cmp=DAT)

Feel free to reach out with any questions.

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Polo,

I'm not sure if you want to try and access it through the user interface or through the AOT so I listed both options.

The SysTableBrowser is not accesible through a path in the UI you can only get it to their manual URL manipulation using the syntax I listed in my previous post.

In the AOT, you can find it by searching to sysTableBrowser and selecting the menu item to duplicate.


------------------------------
Alex Meyer
Director of Microsoft Software Development
Fastpath
Des Moines, IA
------------------------------

Original Message:
Sent: Aug 05, 2022 09:12 AM
From: Polo Garcia
Subject: Table Browser Security Access

Hi, Alex,

I am interested in doing this as well. Can you please tell me where that sysTableBrowser menu is? 

Thank you,
Polo

------------------------------
Polo Garcia
Maple Leaf Farms, Inc.

Original Message:
Sent: Feb 25, 2020 11:23 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

So I was able to get this to work by doing the following:

1) Creating a copy of the sysTableBrowser menu item display into a project
2) Changing the Allow Root Navigation parameter from No -> Yes

3) Create/assign this copied menu item to a privilege/role (here is an example)

4) When this is assigned to a user and they navigate to <RootD365FOEnv>/?mi=SysTableBrowserCopy&tableName=<tableName>&cmp=<companyId> they should see the table browser
(for example to see the UserInfo table: /?mi=SysTableBrowserCopy&tableName=UserInfo&cmp=DAT)

Feel free to reach out with any questions.

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Wonderful! Thank you, Alex!

Polo

------------------------------
Polo Garcia
Maple Leaf Farms, Inc.
Leesburg
------------------------------

Original Message:
Sent: Aug 05, 2022 12:58 PM
From: Alex Meyer
Subject: Table Browser Security Access

Polo,

I'm not sure if you want to try and access it through the user interface or through the AOT so I listed both options.

The SysTableBrowser is not accesible through a path in the UI you can only get it to their manual URL manipulation using the syntax I listed in my previous post.

In the AOT, you can find it by searching to sysTableBrowser and selecting the menu item to duplicate.


------------------------------
Alex Meyer
Director of Microsoft Software Development
Fastpath
Des Moines, IA

Original Message:
Sent: Aug 05, 2022 09:12 AM
From: Polo Garcia
Subject: Table Browser Security Access

Hi, Alex,

I am interested in doing this as well. Can you please tell me where that sysTableBrowser menu is? 

Thank you,
Polo

------------------------------
Polo Garcia
Maple Leaf Farms, Inc.

Original Message:
Sent: Feb 25, 2020 11:23 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

So I was able to get this to work by doing the following:

1) Creating a copy of the sysTableBrowser menu item display into a project
2) Changing the Allow Root Navigation parameter from No -> Yes

3) Create/assign this copied menu item to a privilege/role (here is an example)

4) When this is assigned to a user and they navigate to <RootD365FOEnv>/?mi=SysTableBrowserCopy&tableName=<tableName>&cmp=<companyId> they should see the table browser
(for example to see the UserInfo table: /?mi=SysTableBrowserCopy&tableName=UserInfo&cmp=DAT)

Feel free to reach out with any questions.

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Thanks so much, Alex! We'll see if we can get our developers to build an extension to the table to enable access for non-sys admins. Thanks again for the responses and suggestion, much appreciated!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Hi Kerstin,

However the method provided by Alex is working, wouldn't it be better to provide a specific form to view the errors more easy? Microsoft might in future decide to remove from or further limit the table browser on the production environment. In that case, I would rather not depend on this form but provide the users a specific form where they can do their specific troubleshooting.

------------------------------
kind regards,

André Arnaud de Calavon
Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions
------------------------------

Original Message:
Sent: Feb 25, 2020 11:28 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Thanks so much, Alex! We'll see if we can get our developers to build an extension to the table to enable access for non-sys admins. Thanks again for the responses and suggestion, much appreciated!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Hi André,
Thanks for the suggestion, I totally agree. We thought the table browser would be easy (because only sys admins tested it before) and a quicker solution for the time-being than building a report or screen for them with the required information. Long-term, that's definitely our goal, we just thought the table browser could provide them with the information in the short-term.
Thanks again!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

Original Message:
Sent: Feb 26, 2020 05:40 PM
From: André Arnaud de Calavon
Subject: Table Browser Security Access

Hi Kerstin,

However the method provided by Alex is working, wouldn't it be better to provide a specific form to view the errors more easy? Microsoft might in future decide to remove from or further limit the table browser on the production environment. In that case, I would rather not depend on this form but provide the users a specific form where they can do their specific troubleshooting.

------------------------------
kind regards,

André Arnaud de Calavon
Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions

Original Message:
Sent: Feb 25, 2020 11:28 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Thanks so much, Alex! We'll see if we can get our developers to build an extension to the table to enable access for non-sys admins. Thanks again for the responses and suggestion, much appreciated!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------

We had similar discussions for D365. We did not provide the table browser, because the table browser might allow access to all tables. And we do not want that all users can read all finance data, all prices, all HR data in D365, etc. 


------------------------------
Katja Schebler
NORMA GROUP Holding GmbH
Maintal
------------------------------

Original Message:
Sent: Feb 27, 2020 07:51 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi André,
Thanks for the suggestion, I totally agree. We thought the table browser would be easy (because only sys admins tested it before) and a quicker solution for the time-being than building a report or screen for them with the required information. Long-term, that's definitely our goal, we just thought the table browser could provide them with the information in the short-term.
Thanks again!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 26, 2020 05:40 PM
From: André Arnaud de Calavon
Subject: Table Browser Security Access

Hi Kerstin,

However the method provided by Alex is working, wouldn't it be better to provide a specific form to view the errors more easy? Microsoft might in future decide to remove from or further limit the table browser on the production environment. In that case, I would rather not depend on this form but provide the users a specific form where they can do their specific troubleshooting.

------------------------------
kind regards,

André Arnaud de Calavon
Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions

Original Message:
Sent: Feb 25, 2020 11:28 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Thanks so much, Alex! We'll see if we can get our developers to build an extension to the table to enable access for non-sys admins. Thanks again for the responses and suggestion, much appreciated!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 10:45 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

It appears that the Allow Root Navigation option on the sysTableBrowser menu item display is set to No. This means that non-SysAdmins cannot directly navigate to this menu item without a context.

I'm not sure what the best option going forward would be to a non-SysAdmin user, maybe creating a 'dummy' local extension so you can change this property?

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 25, 2020 09:42 AM
From: Kerstin Newman
Subject: Table Browser Security Access

Hi Alex,
Thanks for your response!

It does work for anyone with sys admin privileges just fine, but anyone else is getting the below error, even for OOB tables:

The users are getting the error even though they have the "Open table browser" privilege assigned to their role.. Any ideas as to how I can solve this?

Thank you!

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON

Original Message:
Sent: Feb 25, 2020 09:29 AM
From: Alex Meyer
Subject: Table Browser Security Access

Kerstin,

Can you verify what error you are seeing when the users try to access the table browser?

I have verified that the table browser feature itself still works in a PU24, PU31, and PU33 environments (just happened to have those versions).

------------------------------
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA

Original Message:
Sent: Feb 24, 2020 11:31 AM
From: Kerstin Newman
Subject: Table Browser Security Access

We're trying to grant access to some of our warehouse users to see tables rather than having to find issues through the UI browsing. Even though I have assigned the specific privilege for using the table browser and the specific tables they should have access to, they are getting an error and can't access ANY tables, custom or OOB.
Any ideas from anyone on what I am missing? We're on 10.0.5 (PU29) but are upgrading to 10.0.8 (PU32) in the next few weeks.

------------------------------
Kerstin Newman
Business Analyst
StarTech.com
London ON
------------------------------