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


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

  2. Luis Martin Moderator

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

    Luis Martin

    All in Love is Fair
    Stevie Wonder

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

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

  4. MohammedU New Member

    Check SP_HELPROTECT procedure output....

    Mohammed U.

Share This Page