Sql list users and roles

-- 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

20 votes272 views3 answers
How to open postgresql in mac
SQL
0 vote242 views1 answer
Wordpress sql change site url
SQL
5 votes257 views1 answer
Minecraft java port number
SQL
0 vote274 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
-1 vote256 views3 answers
SQL to LINQ converter
SQL
0 vote300 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
2 votes259 views1 answer
Sql missing records from another table
SQL
1 vote256 views1 answer
Mysql select another database
SQL
1 vote234 views1 answer
Mysql date diff in seconds
SQL
0 vote237 views1 answer
Postgresql import data from csv
SQL