Determining all permissions for an account

From: Jay (msnews.microsoft.com)
Date: 11/06/02 

From: "Jay" <msnews.microsoft.com>
Date: Tue, 5 Nov 2002 20:25:36 -0500

How is it possible to view all permissions (insert, update, delete, exec,
etc.) for all objects in all databases for a specific account? Is there a
procedure that'll accept a username as a parameter then return this info?
If not, anyone know if there is a procedure like this out there somewhere?

Relevant Pages

  • Re: one SQL DB getting info from another - user setup?
    ... It appears from your narrative that the Main and DB1 databases ... EXEC sp_helpdb 'Main' ... SQL 2000 SP3 and is turned off by default. ... > In the permissions for Main, USER1 and USER2 are listed, but have NO ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedures and Security
    ... databases are owned by different people. ... >>I cannot only give EXEC permissions to a login on my SQL ... > the SELECT and UPDATE commands that are executed in the SP! ...
    (microsoft.public.sqlserver.programming)
  • Re: Read Only User - One Database
    ... No....nothing about someone creating the guest account but I ... don't know what databases the user is accessing. ... >> that user permissions to select from all user tables. ...
    (microsoft.public.sqlserver.security)
  • Re: Read Only User - One Database
    ... Which other databases? ... If a user doesn't have an account ... to log into the database and the guest account is enabled, ... that user permissions to select from all user tables. ...
    (microsoft.public.sqlserver.security)
  • Re: Read Only User - One Database
    ... the databases on the server. ... > I've unchecked the db_datareader role and only gave select permissions to 2 ... >> the guest account enabled. ... >> to log into the database and the guest account is enabled, ...
    (microsoft.public.sqlserver.security)
Quantcast