Identify Orphaned Users

• Muralidharan Venkatraman-417748

  Mr or Mrs. 500

  Points: 546

  More actions

  October 1, 2008 at 9:20 am

  #154777

  I am using sql server 2005 and have orphaned db users.

  How to identify which are orphaned users and which are not?

  Much appreciate if i can get a quick response in this regard.

  Thanks

  Murali

• VastSQL

  SSC-Dedicated

  Points: 36069

  More actions

  October 1, 2008 at 9:42 am

  #879579

  USE THIS QUERY

  sp_change_users_login 'REPORT'

  Report: Lists the users, and their corresponding security identifiers (SID), that are in the current database, not linked to any login.

  user and login must be NULL, a zero-length string (‘‘), or not specified.

• Muralidharan Venkatraman-417748

  Mr or Mrs. 500

  Points: 546

  More actions

  October 1, 2008 at 11:38 am

  #879653

  Cool, thx