SELECT *
FROM sys database_principals AS pr
INNER JOIN sys.database_permissions AS pe
ON pe.grantee_principal_id = pr.principal_id
INNER JOIN sys.objects AS o
ON pe . major_id = o . object_id
INNER JOIN sys.schemas AS s
ON o.schema_id = s.schema_id
ORDER BY pr.name
SELECT
pr.name
, pe.type
, pe.permission_name
, pe.state_desc
, o.name
, o.object_id
FROM sys.database_principals AS pr
INNER JOIN sys.database_permissions AS pe ON pe.grantee_principal_id = pr.principal_id
INNER JOIN sys.objects AS o ON pe.major_id = o.object_id
INNER JOIN sys.schemas AS s ON o.schema_id = s.schema_id
SELECT
pr.name
, pe.type
, pe.permission_name
, pe.state_desc
, o.name as object_name
, o.object_id
FROM sys.database_principals AS pr
INNER JOIN sys.database_permissions AS pe ON pe.grantee_principal_id = pr.principal_id
INNER JOIN sys.objects AS o ON pe.major_id = o.object_id
INNER JOIN sys.schemas AS s ON o.schema_id = s.schema_id
ORDER BY pr.name, pe.permission_name, o.name
'연구개발 > SQL2008' 카테고리의 다른 글
XML로 데이터를 만들어서 SP에서 처리하는 방법(sp_xml_removedocument) (0) | 2011.03.21 |
---|---|
xp_cmdshell enable and disable (0) | 2010.05.25 |
같은 그룹의 데이터를 붙여서 출력하기 (0) | 2010.05.25 |
SQL Server를 실행하는 서버 사이에서 데이터베이스를 이동할 때 사용 권한 문제를 해결하는 방법 (0) | 2010.05.23 |
IP 주소 범위 체크 (0) | 2010.05.20 |