Posted by Bruce on 03/14/07 13:29

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.googlegroups.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

[Back to original message]