To check for orphaned users in a database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rinu Philip » To check for orphaned users in a database

To check for orphaned users in a database

Rate Topic

Display Mode

Topic Options

Author

Message

rinu philip

Posted Monday, July 21, 2008 10:51 PM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:03 AM
Points: 202, Visits: 321

Comments posted to this topic are about the item To check for orphaned users in a database

Post #538144

cweekes

Posted Tuesday, September 23, 2008 7:08 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 12:52 PM
Points: 40, Visits: 52

There is also a built-in stored procedure called 'sp_change_users_login'. It works on the current database and only for sql accounts, not windows logins. It can be used to list orphaned users and to reconnect them. I am not sure if it is available before SQL 2005.

Post #574293

don.schaeffer

Posted Wednesday, September 24, 2008 10:31 AM

Valued Member

Group: General Forum Members
Last Login: Monday, May 20, 2013 2:56 PM
Points: 60, Visits: 634

Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.

Post #575390

« Prev Topic | Next Topic »

Permissions