SQLServerCentral.com Content tagged Security, Logins

Script to clean up “Windows” logins no longer in AD

Tue, 12 Mar 2013 06:00:00 UT

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...

Logins vs Users

Wed, 12 Dec 2012 07:00:00 UT

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

Remove Logins Script

Thu, 05 Apr 2012 06:00:00 UT

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.

Logins created in the last X Days

Fri, 23 Dec 2011 07:00:00 UT

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.

Re-generating SQL Server Logins

Tue, 08 Feb 2011 07:00:00 UT

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.

Script DB Level Permissions v2.1

Wed, 02 Feb 2011 07:00:00 UT

Scripts role membership, object-level permissions for all DB users.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

Script DB Level Permissions v2.1

Wed, 02 Feb 2011 07:00:00 UT

Scripts role membership, object-level permissions for all DB users.

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

Mon, 28 Dec 2009 07:00:00 UT

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.

Securing SQL with access control and login monitoring

Mon, 16 Feb 2009 07:00:00 UT

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.

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

Logins created in the last X Days

Fri, 23 Dec 2011 07:00:00 UT

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.