DBA 大小事處理記錄

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