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 Logic of Inaccessible Function (3d)

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

Adding a new column to existing table (32d)

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

High Availability Connection problem (37d)

Designing SQL Database for Museum Membership System .NET Facing Issues with Visitor Data (48d)

Find gaps in start stop times on mutliple overlapping rows (52d)

Databricks Truncates Rows in SQL (65d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources