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 5 of 5   

SQL Authentication Via AD Groups Part III: What About Orphaned Users?

With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.  Read more...
By John F. Tamburo 2016/07/18 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 1,712 reads

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 | 906 reads

Orphaned users

By Jens-Peter Giersch 2013/10/31 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,171 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,922 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,151 reads
   Items 1 to 5 of 5   
users (2)    
active directory (1)    
backup and restore (1)    
blogs (1)    
database users (1)    
integrated security. (1)    
sql server (1)