Re: Retrieving ALL Object Privs for ALL Users in ALL Databases

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/15/05 

Date: Sun, 15 May 2005 15:14:31 +0530

Hi,

Execute SP_helprotect from Query Analyzer. This will give you the full
permission for all users in a database. If you have multiple database then
either execute the stored procedure sepeeately for each databases or write a
script to fire this procedure for all databases.

Thanks
Hari
SQL Server MVP

"Michelle" <smiley2211@yahoo.com> wrote in message
news:OPhCB0$VFHA.2684@TK2MSFTNGP09.phx.gbl...
> Hi All,
>
> Does someone have a procedure that will loop through ALL databases and get
> the object priviledges for ALL users in the database?
>
> Thanks...M
>

Relevant Pages

  • Re: DB access for web apps
    ... For stored procedures in your database, you will have to give an explicit ... EXECUTE permission to this user. ...
    (microsoft.public.sqlserver.security)
  • Re: Execute stored procedure only
    ... You need CONNECT capability to be able to get into the database and execute ... You can compare this to having permission to eat a piece of pie, ... Should I not be able to just execute SP through QA? ... right to execute stored procedure in database called "mydatabase". ...
    (microsoft.public.sqlserver.security)
  • Re: Cross-database execution permissions with certificates and sch
    ... activated user cannot access objects in other schemas in this database. ... injection is defended against, however, the threat exists anywhere EXECUTE ... CREATE USER dispatcher ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLCE performance from .NET CF v2.0
    ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
    (microsoft.public.dotnet.framework.compactframework)