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

From: Uri Dimant (urid_at_iscar.co.il)
Date: 05/15/05

  • Next message: Hari Prasad: "Re: Retrieving ALL Object Privs for ALL Users in ALL Databases" 
    Date: Sun, 15 May 2005 12:39:14 +0300

    Hi
    >From Aaron Bertrand
    This will only cover those who have
    been explicitly given access to the procs using GRANT.

    DECLARE @username VARCHAR(32)
    SELECT @username = '???'
    SELECT o.name, CanExec = CASE WHEN p.id = o.id THEN 'Yes' ELSE 'No' END
     FROM sysobjects o LEFT OUTER JOIN syspermissions p
     ON o.id = p.id
    AND p.grantee = USER_ID(@username)

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

  • Next message: Hari Prasad: "Re: Retrieving ALL Object Privs for ALL Users in ALL Databases"

    Relevant Pages

    • Re: Find Database Users
      ... been explicitly given access to the procs using GRANT. ... SELECT @username = '???' ... FROM sysobjects o LEFT OUTER JOIN syspermissions p ...
      (microsoft.public.sqlserver.security)
    • Re: Non-logged Brute Force Attack Vulnerability for Fantastico-Created Databases on cPanel Based Hos
      ... login & password which can allow you to perform a "Show Databases" SQL ... available databases at MySQL, but dunno how to do it! ... > used to enact a brute force attack on mysql databases on the server. ... > and username ARE the same. ...
      (Bugtraq)
    • Re: Locked out
      ... I was able to resolve the problem by just setting the macro security to low. ... Now I can open my databases without Access prompting me for a username and ... >> provide any username and password. ... Now it requires username and password for all databases including ...
      (microsoft.public.access.security)
    • Re: Access mdb file
      ... Do I need to use create connection or create database? ... Is there a default username and password I should ... ENDIF ... >>> CLOSE DATABASES ...
      (microsoft.public.fox.programmer.exchange)
    • Non-logged Brute Force Attack Vulnerability for Fantastico-Created Databases on cPanel Based Hosts
      ... High, full compromise of local databases, password retrieval ... cPanel is one of the leading and most feature filled scripted webhosting ... used to enact a brute force attack on mysql databases on the server. ... and username ARE the same. ...
      (Bugtraq)