Friday, December 11, 2015

Dynamics NAV - User Permissions View - User Access List

View showing all users and all assigned permission groups

SELECT dbo.[Access Control].[Company Name], dbo.[User].[User Name], dbo.[Access Control].[Role ID]

FROM dbo.[Access Control] INNER JOIN

dbo.[User] ON dbo.[Access Control].[User Security ID] = dbo.[User].[User Security ID]

No comments:

Post a Comment