摘要： WITH perms_cte as(select USER_NAME(p.grantee_principal_id) AS principal_name,dp.principal_id,dp.type_desc AS principal_type_desc,p.class_desc,OBJECT_NAME(p.major_id) AS object_name,p.permission_name,p.state_desc AS permission_state_desc from sys.database_permissions pinner JOIN sys.database_principa 阅读全文