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

Add a script

   Items 1 to 20 of 42    Next 20 >>
 

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 | 1,238 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |  Briefcase | 1,339 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 | 2,478 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,113 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 | 513 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,299 reads

Security Audit Db_DataReader

Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.  Read more...
By Hawkeye_DBA 2011/04/11 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 818 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,382 reads

Script DB Level Permissions v2

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 0001/01/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 2,401 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,279 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 | 1,692 reads

SQL Server Port Number Script

This is best run through SSMS 2008 against multiple server. When done so, it will display the port number that SQL is listening on.   Read more...
By Gregory Ferdinandsen 2010/05/04 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 2,072 reads

SQL Server Access Restriction

Restrict Access to SQL by HostName, IP, Application Name, etc...  Read more...
By Gregory Ferdinandsen 0001/01/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 2,603 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 3,025 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2009/12/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 2,457 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 5,112 reads

Find SQL Server Authentication Mode Configuration

Quick Method to find Configured???????????????????????? Authentication Mode  Read more...
By Vijendran R 2009/07/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 772 reads

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.  Read more...
By mobasha B 2009/04/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 1,013 reads

List all permission in all databases

This script will allow you get all the users and roles with permission on objects on all databases.  Read more...
By Alejandro Pelc 0001/01/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 12,163 reads

Determine Users with Permission on an Object

This script will walk the hierarchical chain of users and roles to find users with permissions on an object.  Read more...
By Charles Hawkins 2009/03/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 1,332 reads
   Items 1 to 20 of 42    Next 20 >>