close
SELECT A.class_desc AS 等級
,OBJECT_NAME(major_id) AS 物件名
,B.name AS 被賦予帳號
,(SELECT name FROM sys.database_principals WHERE principal_id=A.grantor_principal_id) AS 授權帳號
,permission_name AS 權限類型
,state_desc AS 允許_不允許
FROM sys.database_permissions AS A
JOIN sys.database_principals AS B
ON a.grantee_principal_id = B.principal_id
WHERE A.major_id> = 0
order by 3
資料來源:
http://myericho.blogspot.tw/2014/06/sql-server-schema_6.html
文章標籤
全站熱搜