sql server roles and users

Solutions on MaxInterview for sql server roles and users by the best coders in the world

showing results for - "sql server roles and users"
Abdoulaye
23 Feb 2017
1-- SQL Server: list of users and roles
2SELECT dp.NAME      AS principal_name,
3       dp.TYPE_DESC AS principal_type_desc,
4       o.NAME       AS object_name,
5       p.PERMISSION_NAME,
6       p.STATE_DESC AS permission_state_desc
7FROM sys.database_permissions p
8         LEFT OUTER JOIN sys.all_objects o
9                         ON p.MAJOR_ID = o.OBJECT_ID
10         INNER JOIN sys.database_principals dp
11                    ON p.GRANTEE_PRINCIPAL_ID = dp.PRINCIPAL_ID;
queries leading to this page
sql show users permissionssql server check user permissions on databaselist all permissions for a user sql serverto sql query using role permissionssql server show users and rolessql list users and roleshow to check user permissions on sql serverget current permissions t sql for a useruser roles sqlgrant permissions to a role sql servergrant role permissions sqlsql server grant role to usersql select users with rolessql query user permissionshow to grant read write permission to user defined role in sql serversql user rolesusers roles and permissions table sqlhow to grant all permissions to user in sql serversql select users and rolesfind the list of users and their roles in the databases using sql servermssql show permissions for userpermission sql userdatabase structure with user roles and permissionssql server grant all permission to user command linesql server grant all permissions to usersql server add permissions to usersql server list users and rolesgive role permissions sqllist the roles for a user mssql server roles in sql serversql server grant all permissions to a useradd user permission to database sql serversql server rolessql server users and rolessql server get list of all users and rolesmssql user permissionsuser permissions sqlrole permission user dbgrant permission sql server to userlist grant permissions for a user mssqlsql server script user permissionssql server list roles for usermicrosoft sql see user permissionview user roles in sql serversql role permissionssql server roles and permissionsmssql show user database permissionsassign permissions to select the user sql serverlist sql users and roleshow to give permission to user in sql serverms sql user rolessql user permissionshow to give database permissions to user in sql server for single databasesql server create user and grant permission command linegive user permission to specific database sql serversql server roles and users