Re: Get All User Permissions

From: Prince (mkumar@lante.com)
Date: 08/30/02 

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

Relevant Pages

  • Protecting against dDOS bots (was: Newbie php problem)
    ... The form mail script posted that was used, ... requires the applicant to pass some kind of Turing test, ... Turing test if the account balance ever drops to zero. ... Log into the same account repeatedly, which consumes your credit ...
    (alt.php)
  • Re: Entourage account setup applescript not working
    ... I pasted the script at the end just in case. ... When comparing the account settings on 2 computers, ... This script assists a user with the setup of his Exchange account ... Customize the network and server properties below with information ...
    (microsoft.public.mac.office.entourage)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: Local account creation
    ... While this script works fine for my 2003 environment, ... use the script in a startup GPO so that there a generic local admin account ... Dim objNetwork, strComputer, strUser ...
    (microsoft.public.windows.server.scripting)
  • Re: How to change default of "Add to Address Book" command
    ... Script Editor, I did access the group using Google simply because my ... even though the Entourage source for my message clearly says ... Exchange account's Contacts address book. ... If you happen to have more than one Exchange account then ...
    (microsoft.public.mac.office.entourage)