Hello,

I am trying to write a script using SQL Server 2000 to list all of the
roles that have any permissions on a specified object (view, table,
sp, etc.). Essentially I am trying to script what is displayed when
one selects the 'list only users/user-defined database roles/public
with permissions to this object' option under 'manage permissions' in
EM but without showing individual users, only roles. I've looked at
the system sp's and the information_schema views but none of those
seem to give this information. Am I going to have to look directly at
the system tables? If anyone has a script that does this for a
specified object or can point me to more specific information on how
to do this I'd appreciate it. Thanks!

Bruce

Have you checked "sp_helprotect" , this one is permissions for all objects,


--

Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>


"Bruce" <deluxeinformation (AT) gmail (DOT) com> wrote

On Mar 14, 4:41 am, "Jack Vamvas" <DEL_TO_RE... (AT) del (DOT) com> wrote:

Thank you. I don't know how I overlooked that one. Sometimes I wish
BOL was laid out a little differently.

Bruce