SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Logins Rss

Search for any content tagged logins

   Items 1 to 7 of 7   

Deploy Security Changes with Copy-SqlLogin

Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.  Read more...
By Steve Jones 2016/11/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,400 reads

Prevent and Log Certain SQL Server Login Attempts

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).   Read more...
By Additional Articles 2015/04/14 | Source: MSSQLTips.com | Category: logins
Rating: (not yet rated)  Rate this |   Briefcase | 7,247 reads

Database User Superfluousness In SQL Server

In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.  Read more...
By Thomas Knight 2014/02/04 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,921 reads

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.   Read more...
By Additional Articles 2011/02/08 | Source: Database Journal | Category: security
Rating:  Rate this |   Briefcase | 5,492 reads

Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases

Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.  Read more...
By Yichang Chen 2009/12/28 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,025 reads

Auditing Failed Logins in SQL Server

An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?  Read more...
By Additional Articles 2009/05/06 | Source: MSSQLTips.com | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 3,457 reads

Securing SQL with access control and login monitoring

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.  Read more...
By Additional Articles 2009/02/16 | Source: SearchSQLServer | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 3,061 reads
   Items 1 to 7 of 7