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

Error 1204 every 13-15 minutes (4h)

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

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

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

Peer to Peer Replication is not working between 2 different machines (50d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (84d)

Subscription sends report with data to one user but empty report to other users (86d)

Pivot Tables in SQL (93d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources