Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Boca Raton, FL
    Posts
    5

    Unanswered: See All Users With DBO?

    Is there a way in SQL 2000 to view all users that have DBO access? I can go from db to db or all in general? My company has about 4000 employees and i need to tighten up on security and remove dbo access from people who shouldnt have it, i would rather run a system procedure and go from there then have to check every single users access. Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I think you can get the information with this query:

    select *
    from sysusers
    where substring (roles, 1, 4) = 0x01


    I do not have many users that are part of several groups, so I can not guarantee this will work in all cases.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    EXEC sp_helpsrvrolemember 'sysadmin' and refer to BOL for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •