/SQL/Sql server user permissions and roles

Sql server user permissions 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

2 votes350 views2 answers
Checking data type in sql server
SQL
1 vote358 views1 answer
How to check the mysql version mac
SQL
7 votes372 views2 answers
Postgres concat
SQL
15 votes366 views5 answers
If null mysql
SQL
0 vote358 views1 answer
User defined variables in sql
SQL
0 vote371 views2 answers
Oracle select
SQL
5 votes361 views2 answers
Copy data from one database to another
SQL
0 vote395 views2 answers
Get item by composite primary key mysql
SQL
4 votes310 views1 answer
And or sql order of operations
SQL
0 vote405 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