sql server - List all permissions for a given role? - Database Administrators Stack Exchange
SELECT DB_NAME() AS 'DBName'
,p.[name] AS 'PrincipalName'
,p.[type_desc] AS 'PrincipalType'
,p2.[name] AS 'GrantedBy'
,dbp.[permission_name]
,dbp.[state_desc]
,so.[Name] AS 'ObjectName'
,so.[type_desc] AS 'ObjectType'
FROM [sys].[database_permissions] dbp LEFT JOIN [sys].[objects] so
ON dbp.[major_id] = so.[object_id] LEFT JOIN [sys].[database_principals] p
ON dbp.[grantee_principal_id] = p.[principal_id] LEFT JOIN [sys].[database_principals] p2
ON dbp.[grantor_principal_id] = p2.[principal_id]

WHERE p.[name] = 'blah'
sql  role  permissions 
6 weeks ago
« earlier      
2017 addins admin adr agile aidalai ajax angular angular2 angular2.0 angular4 angularjs api architecture array articles asp asp.net async async. augury auto-index automation await azure background blacklist boilerplate books bootstrap boss bre breach browser build build-tool builder builders businessrule c# callback cascade changeset channel charts cheap children chrome chunk client codefirst coding collaboration command-line comment commit complex component components compression conditional console core cors counsel courses cqrs d3 dallas dapper data date debugging decimals delete design dev development devtools diagram dieta display dist documentation download drivers dropdown dx1ae ebook ebooks ecmascript6 edging ef ef6 email ember emulator encoding engine engineering entityframework equifax error es6 events excel extensions fiddle file filter flights flowerbed fluent forbes form format forms free frisco furniture gas get git githttpclient grid group groups gt6 guid guitar gzip hcm hr html http httpclient httpcontext https identity indexing innovation input insert instance interceptor international it javascript jquery kendo keto kids kodi learning lessons library linq linqpad lite-server live localhost log4net logging management martin mecano merge messaging metrics microsoft mining mock modal moq mssql music mvc mvvm navigation nested net ngreactiveforms node npm nuget nvm nyt octopus optimization orgchart orm outlook parenting passport patch patterns paycor payroll pedal pepino performance permissions piano pipeline pivot plugin plugins poco podcast postman production productivity profiler programming progressive properties provider proxy ps2 psychology r react reactjs redirect repos repository resharper resources rest roku role rules sanitizing scalable scraper scraping script search sequence service setup shortguid signalr silent smoothie software sql sqlexpress sqlmanagementstudio ssl ssms stateless stats storage store survey switch synology systemjs t4 tables tabs tag tags tech technology template test tfs theory therapist therapy thoughtworks timeout tips tools topshelf tracing tracker tracking transaction travel treadmill trends tutorial typescript unittest upgrade usps validation verbose version versioning visualization visualstudio vs2015 vs2017 web webapi webpack website websockets webutils whatsapp windows10 wireframe word wordcloud workitem

Copy this bookmark:



description:


tags: