Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

To check for orphaned users in a database Expand / Collapse
Author
Message
Posted Monday, July 21, 2008 10:51 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 3:23 AM
Points: 207, Visits: 425
Comments posted to this topic are about the item To check for orphaned users in a database
Post #538144
Posted Tuesday, September 23, 2008 7:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Wednesday, September 24, 2008 10:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 7:22 AM
Points: 69, Visits: 770
Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.
Post #575390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse