Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, September 19, 2016 4:41 PM
Points: 213, Visits: 496
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: Tuesday, September 29, 2015 6:15 AM
Points: 40, Visits: 57
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
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:54 AM
Points: 87, Visits: 1,040
Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.
Post #575390
Posted Monday, May 2, 2016 1:16 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:55 AM
Points: 8,101, Visits: 812
Thanks for the script.
Post #1782655
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse