日期:2014-05-18 浏览次数:20418 次
Select UserName = USERS.name, ObjectName = o.name, PermissionName = prmssn.permission_name From sys.database_permissions prmssn INNER JOIN sys.database_principals AS grantee ON grantee.principal_id = prmssn.grantee_principal_id JOIN sys.sysusers USERS ON USERS.sid=grantee.sid JOIN sys.objects o on major_id=o.object_id Order By 1, 2