SQL Server
2015. 11. 13. 18:37
유저가 권한을 가진 오브젝트 보기
select b.name as cObjectName , c.name as cAccount , schema_name(b.[schema_id]) as cSchema , b.[type] as cObjectTypefrom sys.database_permissions as a inner join sys.all_objects as b on b.[object_id] = a.major_id inner join sys.database_principals as c on c.principal_id = a.grantee_principal_idwhere a.class = 1 and c.name = N'test'go