Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
Security
Search for
any
content tagged
security
Add a script
Items 1 to 20 of 47
Next 20 >>
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
|
952 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,502 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
|
880 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
|
594 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,132 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
|
2,426 reads
who can do what?
list each user has the right to do
Read more...
By
Ricardo Leka
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
security
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,035 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,926 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,461 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
|
571 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,550 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
|
930 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,557 reads
Script DB Level Permissions v2.1
Scripts role membership, object-level permissions for all DB users.
Read more...
By
S. Kusen
2011/02/02
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,966 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,411 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,926 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,235 reads
SQL Server Access Restriction
Restrict Access to SQL by HostName, IP, Application Name, etc...
Read more...
By
Gregory Ferdinandsen
2011/07/21
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,834 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,391 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
|
3,150 reads
Items 1 to 20 of 47
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.