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,389 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,192 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,808 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,254 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,406 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,963 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,213 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 | 836 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,182 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,070 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |   Briefcase | 2,183 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,084 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,603 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 | 608 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,654 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,623 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,552 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,475 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,018 reads
   Items 1 to 20 of 51    Older >>