Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

SP to List Role Permissions

By Brent Huscher on 14 September 2000 | Tags: Security Roles

This script is updated from SQL Server 6.5. It will list all the GRANTed permissions in a database for a given role.

Related Articles

Using Application Roles (30 October 2000)

Other Recent Forum Posts

Using SQL Databases for Digital Membership Card Software (2d)

`sp_columns_ex behaves differently in containerized Windows environment` (4d)

Reverting or rollback on an Availability Group upgrade to new nodes (11d)

More efficient qurty (15d)

Error 1204 every 13-15 minutes (15d)

SQL Server 2019 CU vs GDR update which one is correct? (23d)

Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508 (55d)

Improving update statistics process for 6 big tables (65d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources