Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Security
Refine your search with one of the following additional tags (with number of items):
Administration
(7)
SQL Server 2000
(2)
Database Roles
(1)
Maintenance
(1)
SQL Server 2005
(3)
Administrator
(1)
DDL
(1)
PUBLIC
(1)
T-SQL
(3)
Audit
(1)
Extended StoredProcedure
(1)
SID
(1)
Role
(2)
Backup
(1)
Guest User
(1)
sp_msforeachdb
(1)
SQL 2005
(2)
Backup/Restore
(1)
Logins
(1)
SQL 2000
(1)
Search for
any
content tagged
Security
Add a script
Items 1 to 17 of 17
List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
Read more...
By
shiva challa
2008/10/02
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
14 reads
db_SProcReader role generator
This script will generate a script that would create a Role called "db_SprocReader" and grants "View Definition" permissions to all the stored procedures.
Read more...
By
shiva challa
2008/09/26
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
7 reads
To check for orphaned users in a database
This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.
Read more...
By
Rinu George Philip
2008/09/23
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4 reads
public access to extended SP's
check public access to extended stored procedures
Read more...
By
Mani Singh
2008/08/08
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
77 reads
Find Guest user access level in all databases
Search for GUEST Access Level in all
Read more...
By
Mani Singh
2008/08/06
|
Source:
SQLServerCentral.com
|
Category:
sp_msforeachdb
Rating:
|
Discuss
|
Briefcase
|
93 reads
Logins created in the last X Days
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
Read more...
By
Mani Singh
2008/07/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
279 reads
usp_SecurCreation - SQL 2k5
Creates statements for securables creation.
Read more...
By
Pedro Lopes
2008/06/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
685 reads
usp_SecurCreation - SQL 2k
Creates statements for securables creation.
Read more...
By
Pedro Lopes
2008/06/26
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
375 reads
usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes
2008/07/16
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
810 reads
Script permissions on all databases
i took the core from a script found in the site for generating permissions and update it.
Read more...
By
mobasha B
2008/05/06
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
891 reads
Convert binary SID to string
Converts a binary SID to string format.
Read more...
By
Todd Engen
2008/04/02
|
Source:
SQLServerCentral.com
|
Category:
SID
Rating:
|
Discuss
|
Briefcase
|
520 reads
Create_sp_help_revlogin_DB
Enhanced sp_help_revlogin
Read more...
By
David A. Long
2008/04/09
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
705 reads
SQL 2005 - List Permission
This script will list user permissions for database objects.
Read more...
By
Sandeep Saretha
2008/03/19
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
1,034 reads
BackUp_DBs.sql
Make backup several databases with a cursor
Read more...
By
f.racionero
2008/03/27
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
744 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
Read more...
By
Ed Vassie
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
SQL 2000
Rating:
|
Discuss
|
Briefcase
|
897 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
Read more...
By
Lester Policarpio
2008/01/25
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
644 reads
GrantExecAllUserAllSpandfunctions.sql
Grant permits execution to all user on all sp and functions
Read more...
By
f.racionero
2008/01/04
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
638 reads
Items 1 to 17 of 17
Most popular
usp_SecurCreation - SQL 2k5
Creates statements for securables creation.
Read more...
By
Pedro Lopes
2008/06/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
685 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
Read more...
By
Ed Vassie
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
SQL 2000
Rating:
|
Discuss
|
Briefcase
|
897 reads
SQL 2005 - List Permission
This script will list user permissions for database objects.
Read more...
By
Sandeep Saretha
2008/03/19
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
1,034 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use