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

SQL 2022 SSMS 20 "smo does not appear to be installed on this computer" (9h)

SQL 2022 SSMS 20 "smo does not appear to be installed on this computer" (9h)

Matching test dates to first entrance date (3d)

ODBC Connection From Access To SQL Failing (4d)

select max from inner join (6d)

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0 (8d)

ROLLUP to calculate Month total for all Categories (26d)

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources