Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Anderson Garcia]

Hello,

I’m trying to search all the users that have super user access. Is there a way to view just those users with super user permission?

Thanks

——————————
Anderson Garcia
IT Support
Joseph’s Gourmet Pasta Company
Haverhill MA
——————————

[Lewis Rosenberg]

Using the Development Environment, look for table #2000000053 (Access Control).  Run that table and filter on the ROLE ID = SUPER.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Crystal Whelan]

Hi,

Not sure what version you are on, but in 2016 you can navigate in the client to Permission Sets and then in the ribbon there is an option to see Permission Set by User. Locate SUPER in the Role ID and anyone that has a check box has those permissions.

——————————
Crystal Whelan
IT Systems Manager
Banneker Industries
North Smithfield RI
——————————
——————————————-

[Alex Apodaca]

Hello,

You can use any application that can run queries and execute the following against your NAV database:

SELECT [User].[User Name], [Role ID], [Company Name]
FROM [Access Control]
  INNER JOIN [User]
    ON [Access Control].[User Security ID] = [User].[User Security ID]
WHERE [Role ID] = ‘SUPER’

——————————
If my response has helped you please mark the answer.

Alex A
Sr. NAV Consultant
Irvine, CA United States
——————————
——————————————-