Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag orphaned users Rss

   Items 1 to 3 of 3   
 

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 | 2,714 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 | 2,906 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 | 3,788 reads
   Items 1 to 3 of 3   
 
Tags
backup / restore (1)    
restore (1)    
security (1)