List Navision Security setting, 列出Navision相关账户的权限

列出特定用户组的权限，以及他们所能访问的公司名称. 

list user name by permission group, and the company name they can access.

SELECT 
AC.[User Security ID]
,AC.[Role ID]
,AC.[Company Name]
,U.[User Name]
FROM [Nav2015].[dbo].[Access Control] AC left join 
[Nav2015].dbo.[User] U on U.[User Security ID] = AC.[User Security ID]
where [Role ID] like 'Super'

列出指定表的权限组

select [Role ID], [Object Type],[Object ID], [Read Permission],[Insert Permission],[Modify Permission],[Delete Permission],[Execute Permission]
from [Nav V5].dbo.[Permission] where [Object Type] like 0 and [Object ID] like 288