Get All User Permissions

From: Jay (msnews.microsoft.com)
Date: 08/30/02 

From: "Jay" <msnews.microsoft.com>
Date: Thu, 29 Aug 2002 21:45:58 -0400

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

  • Re: Multiuser local and server tables
    ... views and tables on SQL Server ... One holds account numbers and the other ... the month and years that they want the report to cover. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report Viewer deployment
    ... created a dataset at run time and bound it to the report and viewed and all ... and check out the user account the ASP.NET worker process is running under ... Double check all your config assumptions ... config and sql server config), turn on auditing at the sql server and ...
    (microsoft.public.dotnet.framework.aspnet)
  • SMS Reporting Issue
    ... We are running SMS 2003 sp1 and having an issue with Reporting. ... summary pages can be viewed but I cannot view the details of a report. ... Microsoft OLE DB Provider for SQL Server ... account being used to run the report; my account and the NT AUTHORITY\SYSTEM ...
    (microsoft.public.sms.misc)
  • 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: Multiple Column Report - esp for Duane Hookom
    ... annual total for that account - it's already in essense a "sum". ... Income Statement - and for my users it needs to. ... ACC2000: How to Print Labels on the Left Margin of a Report: This is the ... The State Controller (SCO) produces Annual Financial Reports for all Special ...
    (microsoft.public.access.reports)