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

0 vote167 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote160 views1 answer
10000000000000000000 am to meters
SQL
0 vote165 views1 answer
How to export table data from mysql table in sql format
SQL
4 votes168 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote176 views1 answer
Why we have to set the password for my sql server
SQL
10 votes204 views6 answers
Mysql set root password
SQL
0 vote184 views1 answer
Create function in microsoft sql server
SQL
3 votes163 views1 answer
Postgres update column with value from another table
SQL
5 votes174 views1 answer
Invalid column name sql
SQL
0 vote175 views2 answers
How to set global time_zone in mysql
SQL