Thank you Paul for leading into resolving my issue.

Janet Mangual
Miami-Dade Water & Sewer Department
3071 SW 38 Ave Miami, FL 33146
www.miamidade.gov
"Delivering Excellence Every Day"

-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x9403014.[Email address protected]
Sent: Friday, May 27, 2005 2:17 PM
To: LazyDBA Discussion
Subject: RE: Grant of a Roles

From BOL: To view the permissions associated with the role, use
sp_helprotect.


-----Original Message-----
From: Mangual Janet A. (WASD)
[mailto:mssqldba-ezmlmshield-x89867465.[Email address protected]
Sent: Friday, May 27, 2005 2:11 PM
To: LazyDBA Discussion
Subject: Grant of a Roles


Another one for the Gurus!!!





How can get a listing containing all grants/permissions of a role?

Janet Mangual
Miami-Dade Water & Sewer Department
3071 SW 38 Ave Miami, FL 33146


MS Sql Server LazyDBA home page