listing User names from SQL Server

• Gary Andrade

  Ten Centuries

  Points: 1028

  More actions

  April 16, 2004 at 1:15 pm

  #85178

  Is there a way to list all users (SQL and NT) that have been set up in Security.  I know I can get this infomation from each database by (select * from sysusers).  That task becomes very cumbersome when you have 20 databases x several servers.  Any suggested tools, scripts or Stored proc would help.

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  April 16, 2004 at 1:32 pm

  #503199

  This will give you the database and users for each database on a server.

  exec sp_msforeachdb 'use ?;select db_name() AS DatabaseName, * from sysusers where issqlrole = 0'

  ---

  
  Shamless self promotion - read my blog http://sirsql.net