Sql server list user permissions

-- SQL Server: list of users and roles
SELECT dp.NAME      AS principal_name,
       dp.TYPE_DESC AS principal_type_desc,
       o.NAME       AS object_name,
       p.PERMISSION_NAME,
       p.STATE_DESC AS permission_state_desc
FROM sys.database_permissions p
         LEFT OUTER JOIN sys.all_objects o
                         ON p.MAJOR_ID = o.OBJECT_ID
         INNER JOIN sys.database_principals dp
                    ON p.GRANTEE_PRINCIPAL_ID = dp.PRINCIPAL_ID;

Source: stackoverflow.com

Similar codes

8 votes213 views3 answers
Postgres connection string
SQL
28 votes205 views6 answers
Mysql change user password
SQL
0 vote194 views1 answer
Mysql disable query caching
SQL
2 votes216 views1 answer
Grant revoke privileges to mysql username
SQL
3 votes222 views1 answer
Oracle undo tablespace schema
SQL
1 vote208 views1 answer
Operator does not exist: integer = text
SQL
4 votes206 views1 answer
Data types in sql
SQL
6 votes203 views1 answer
Oracle desc table primary key
SQL
0 vote231 views1 answer
Character count sql
SQL
1 vote192 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL