Re: Object Permissions query
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/17/04
- Next message: Frank Dulk: "Re: maintenance plan"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: how I combine two case statement into one under same heading"
- In reply to: brian: "Object Permissions query"
- Next in thread: Cindy Gross: "Re: Object Permissions query"
- Reply: Cindy Gross: "Re: Object Permissions query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 08:45:44 +0530
Hi,
You may have refer 2 tables
syspermissions - Which contains the details of permissions given using
'Grant' statement
sysmembers - Which contains roles assigned.
So you may need to write a query based on both the above tables.
Note:
Both the above tables are available in all the databases.
Thanks
Hari
MCDBA
"brian" <anonymous@discussions.microsoft.com> wrote in message
news:DE39B6D0-F397-4EA5-BB80-771136FA0B45@microsoft.com...
> Hi
>
> I am wanting to construct a query to retrieve a list of tables and views
that a user and it's group have access to. This need to include default
group-level permissions, such as ddl_admin, etc.
>
> for instance. I have a user "A" who is part of Group "XYZ". I want to
retrieve a list of views and tables that User "A" or it's parent group
("XYZ") have select permission .
>
> Has anybody done this.
>
> cheers,
> Brian
- Next message: Frank Dulk: "Re: maintenance plan"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: how I combine two case statement into one under same heading"
- In reply to: brian: "Object Permissions query"
- Next in thread: Cindy Gross: "Re: Object Permissions query"
- Reply: Cindy Gross: "Re: Object Permissions query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
