List User's Permissions down to table.column action
- From: "Neil Meyer" <nmeyer@xxxxxxxx>
- Date: Wed, 14 Jun 2006 12:33:53 -0700
Anybody have a script to list a user's effective permissions down to the
table.column [action] level?
With records produced by this script, I would be able to say for example:
userID has select and update permissions on dbo.cdata.cfid through public
role
I saw a similar, recent post on a similar topic on this newsgroup, but the
suggestions did not work for me.
Thanks anybody.
.
- Follow-Ups:
- RE: List User's Permissions down to table.column action
- From: Greg Larsen
- RE: List User's Permissions down to table.column action
- Prev by Date: Re: permissions via roles query (SQL Server 2000)
- Next by Date: Re: Column Encryption via stored procedure
- Previous by thread: How to hide INFORMATION_SCHEMA and sys from users
- Next by thread: RE: List User's Permissions down to table.column action
- Index(es):
Relevant Pages
|
