Show permissions for database user

• radica_pet

  SSC Enthusiast

  Points: 121

  More actions

  July 31, 2009 at 5:51 am

  #103792

  Hi,

  If I grant privileges to database user with GRANT statement,

  is there way to get the list of all permissions that I granted for each database user.

  Can anyone help!

  Thanks

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  July 31, 2009 at 6:15 am

  #1032882

  Is something like this what you are looking for:

  SELECT NAME, permission_name, class_desc , OBJECT_NAME (major_id) , state_desc

  FROM sys.database_permissions dp

  INNER JOIN sys.database_principals pri ON dp.grantee_principal_id = pri.principal_id