Saturday, January 20, 2018
SQL Server Script Repository
Facebook Twitter LinkedIn Google+ Addthis
Term: Orphan Windows Accounts
1 post(s)

SQL Script - List Orphan Users Accounts

By Saleem Hakani on 8/24/2014

User accounts in SQL Server can become orphan whenever a new database is restored or attached. Orphan account means there is no associated login for that user and the when a user logs in to SQL Server using the account which has an orphan user in the database, login account will not be able to access database objects since the user in the database is orphan. Identifying and fixing orphan accounts from all user databases is important for any database administrator. Please note: After identifying an orphan user account, you will need to use SP_Change_Users_Login System Stored Procedure to either 'Auto_Fix','Report','Update_One'. (Example: EXEC sp_change_users_login 'Update_One', 'sqlcommunity', 'sqlcommunity');

Orphan SQL Accounts
Orphan Windows Accounts
Script Categories
Copyright [2014] by SQLCOMMUNITY.COM