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

Birth year between 2 dates (2d)

Add value to a count from another count (10d)

Is the forum dead (23d)

Using Logic of Inaccessible Function (28d)

DT_IMAGE, which is not supported. Use DT_TEXT or DT_NTEXT instead (30d)

Adding a new column to existing table (57d)

Full outer join on every row (scaffolding) (60d)

High Availability Connection problem (62d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources