SP to List Role Permissions

By Brent Huscher on 14 September 2000 | 0 Comments | 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.

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Using Application Roles (30 October 2000)

Other Recent Forum Posts

join between two different formats (2 Replies)

How to connect data with MS SQL Server 2008 (4 Replies)

Selecting a max(date field) in an outer join (5 Replies)

Centralizing of data of 8 different locations (4 Replies)

multiple rows data (4 Replies)

Delete almost duplicates (1 Reply)

Query Question (2 Replies)

MS SQ Server: untrusted domain, but same computer (5 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

SQL Server Resources

Advertise on SQLTeam.com

SQL Server Books

SQLTeam.com Newsletter

Contact Us

About the Site