Re: Get All User Permissions
From: Prince (mkumar@lante.com)
Date: 08/30/02
- Next message: John: "Check if user is a NT Group"
- Previous message: Prince: "Re: Get All User Permissions"
- In reply to: Jay: "Get All User Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Prince" <mkumar@lante.com> Date: Thu, 29 Aug 2002 18:56:25 -0700
INFORMATION_SCHEMA views may solve your problem. Example:
select * from INFORMATION_SCHEMA.TABLE_PRIVILEGES
Look for INFORMATION_SCHEMA views in master database. Additional information
can be found in books online.
If these views do not solve your problem, you may have to write a scripts
using following tables(unless somebody somewhere has that script already):
sysprotects
syspermissions
sysusers
sysobjects
"Jay" <msnews.microsoft.com> wrote in message
news:umuYTa8TCHA.1340@tkmsftngp12...
> Is there a procedure or other functionality available that will allow me
to
> pass in a SQL Server (200) account name and will then report back on all
> permissions that account has in all objects in all databases in the
system?
> Has anyone ever come across such a script?
>
>
- Next message: John: "Check if user is a NT Group"
- Previous message: Prince: "Re: Get All User Permissions"
- In reply to: Jay: "Get All User Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
