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 vote206 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote171 views1 answer
DATE_SUB postgres
SQL
0 vote165 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote171 views1 answer
Oracle current session details
SQL
5 votes203 views1 answer
Oracle get ddl
SQL
0 vote204 views1 answer
Postgresql on conflict pair
SQL
5 votes179 views1 answer
Sort order on two columns sql
SQL
0 vote226 views1 answer
Postgres foreign key multiple columns
SQL
2 votes160 views1 answer
Can you use a where clause for a child query
SQL
0 vote174 views1 answer
Tsql cmd exec script from file
SQL