Home Forums SQL Server 2005 SQL Server 2005 Security how can i get a list of all users with db_owner role in any database RE: how can i get a list of all users with db_owner role in any database

  • September 30, 2009 at 1:52 pm

    #1060165

    In addition to Mark's handy SQL statement, you'll also probably want to report the actual owner of the database, which you can find with:

    SELECT name, suser_sname(owner_sid) FROM sys.databases;