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

Scripts with tag Security Rss

Search for any content tagged security

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 51    Older >>
 

Change password for user 'sa'

Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.   Read more...
By gogulatorul 2014/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,052 reads

Get the all user and their server role

The script give you the list of all users and their respective Server roles  Read more...
By Mitesh Oswal 2014/04/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,152 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,776 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,218 reads

Passively detect attempts to guess passwords

Review the error log for possible brute force or dictionary attacks on your SQL Server instance.  Read more...
By Daniel Brink 2013/05/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,394 reads

Script to find username and corresponding loginname for all user DB

Script to find username and corresponding loginname for all user database in SQL Server  Read more...
By Shashank Srivastava 2013/04/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,955 reads

Change DB Owner to sa for multiple DB's

Changes DB owner to sa for Online DB's where owner is not sa  Read more...
By Riken Patel 2013/04/26 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,203 reads

Security Change Snapshot

This script gives a server level snapshot of recent security changes  Read more...
By Nate Hughes 2013/02/28 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 826 reads

Remove Logins Script

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.  Read more...
By Steve Griffith 2012/04/05 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,181 reads

Audit All Permissions

This script will return all permissions on the server.  Read more...
By Jim Sebastiano 2011/11/16 | Source: SQLServerCentral.com | Category: permission
Rating: |  Discuss |   Briefcase | 3,043 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |   Briefcase | 2,179 reads

Query Active Directory to Display Login Information

Query Active Directory to get information on user logins.  Read more...
By Rudy Panigas 2011/05/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,077 reads

Show SQL authentication login information

View login information for all accounts that use SQL authentication.   Read more...
By Rudy Panigas 2011/05/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,589 reads

Drop Common User in Application database

Run the output of the following script in master database to drop common user in all the application databases  Read more...
By sathish 2011/05/16 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 607 reads

Create Database User

This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.   Read more...
By Vinay Kumar 2011/05/05 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,648 reads

Security Audit Db_DataReader

Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.  Read more...
By Sandy Skaar 2011/04/11 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 987 reads

Script to grant exec permission to all sps in a db

Script to grant exec permission to all sps in a db  Read more...
By Harsha Majety 2010/12/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,620 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,460 reads

Snapshot Dynamicly

How to create a database snapshots dynamically  Read more...
By @fracionero 2010/09/29 | Source: SQLServerCentral.com | Category: sanpshot
Rating: |  Discuss |   Briefcase | 1,473 reads

Windows Group Membership Checker

A script to reveal which logins have access to your sql server via windows groups.   Read more...
By Richard Doering 2010/09/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,011 reads
   Items 1 to 20 of 51    Older >>