[MSSQL] 유저가 가진 권한 목록 조회

use 'DB명';

 

SELECT A.NAME, B.CLASS_DESC, OBJECT_NAME(B.MAJOR_ID) AS [OBJ_NAME], B.PERMISSION_NAME, B.STATE_DESC

 

FROM SYS.DATABASE_PRINCIPALS A

 

INNER JOIN SYS.DATABASE_PERMISSIONS B

 

ON A.PRINCIPAL_ID = B.GRANTEE_PRINCIPAL_ID

 

WHERE A.NAME = 'user명'