Posted by Jack Vamvas on 03/14/07 09:41

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

• Next in forum: Re: A Search for SQLFiles
• Prev in forum: Re: Trying to add a NON-DISTINCT field to a DISTINCT record set in a query.
• Thread view: Re: How to show roles with permissions to objects

[Reply to this message]