SQL Server Performance

Need a query to know who has write access to dbs

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by suleman, Dec 18, 2006.

  1. suleman New Member

    Hi


    I need the list of NT users or groups who can write to a number of dbs on a server.
    can somebody help me with a t-sql on this...

    regards
    Suleman
    suleman, Dec 18, 2006
    #2

  2. Luis Martin Moderator

    EM or Managment Studio give you this information.
    For some reason do you need a T-sql?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Dec 18, 2006
    #2

  3. suleman New Member

    Hi Martin

    As far as i know we can get the list of all users or NT groups irrespective of the permissions they have... But i need a list of all users or NT Groups which have the write access to a few dbs ...

    Regards
    Suleman
    suleman, Dec 18, 2006
    #2

  4. MohammedU New Member

    Check SP_HELPROTECT procedure output....


    Mohammed U.
    MohammedU, Dec 18, 2006
    #2

Share This Page