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

Finding Common Groups (13d)

Birth year between 2 dates (28d)

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

Is the forum dead (48d)

Using Logic of Inaccessible Function (54d)

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

Adding a new column to existing table (83d)

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources