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@gmail.com> wrote in message
news:1173802556.534695.194010@p10g2000cwp.googlegr oups.com...
> 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
>

On Mar 14, 4:41 am, "Jack Vamvas" <DEL_TO_RE...@del.com> wrote:
> 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" <deluxeinformat...@gmail.com> wrote in message
>
> news:1173802556.534695.194010@p10g2000cwp.googlegr oups.com...
>
> > 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


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

Bruce