Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag orphaned users Rss

   Items 1 to 9 of 9   
 

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 832 reads

Fix Orphan Users for Instance Migration

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.  Read more...
By Ajay Dwivedi 2016/01/04 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,178 reads

Fix orphaned users after restoring database to another server

Find and fix orphan users after doing a database restore. It uses cursors but they are pretty minimally intrusive.  Read more...
By Patrick Akhamie 2014/07/17 | Source: SQLServerCentral.com | Category: orphaned users
Rating: |  Discuss |   Briefcase | 1,856 reads

Orphaned users

By Jens-Peter Giersch 2013/10/31 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,153 reads

Steps to Drop an Orphan SQL Server User when it owns a Schema or Role

What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?  Read more...
By Additional Articles 2012/03/16 | Source: MSSQLTips.com | Category: orphaned users
Rating:  Rate this |   Briefcase | 3,038 reads

Fix orphaned users after restoring database to another server.

Script reassigns database orphan users to the matching SQL Server logins.  Read more...
Rating: |  Discuss |   Briefcase | 2,487 reads

Fix all orphaned users in a database

Fix orphaned users on a restored db  Read more...
By Harsha Majety 2010/11/24 | Source: SQLServerCentral.com | Category: orphaned users
Rating: |  Discuss |   Briefcase | 3,107 reads

Please, Sir, I want some more… orphaned database users.

Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....  Read more...
By jameshoward3 2009/12/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,893 reads

Understanding and dealing with orphaned users in a SQL Server database

Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.  Read more...
By Additional Articles 2008/10/09 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 4,083 reads
   Items 1 to 9 of 9   
 
Tags
security (4)    
users (2)    
backup and restore (1)    
blogs (1)    
database users (1)    
logins (1)    
migration (1)    
restore (1)    
sql server (1)