Monday, January 22, 2018

Dynamics NAV - SQL View - Check User Permission Role Assignments

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

No comments:

Post a Comment