<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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 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...
By
Ricardo Leka
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
security
|
SQL Scripts Manager Compatible
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 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
