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

Content with tags Security, orphaned users Rss

   Items 1 to 4 of 4   

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: | Category: security
Rating: |  Discuss |   Briefcase | 852 reads

Orphaned users

By Jens-Peter Giersch 2013/10/31 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,157 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,896 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: | Category: security
Rating:  Rate this |   Briefcase | 4,093 reads
   Items 1 to 4 of 4   
users (2)    
backup and restore (1)    
blogs (1)    
database users (1)    
sql server (1)