Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
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
(10)
Logins
(2)
Database Roles
(1)
PUBLIC
(1)
SQL Server 2005
(5)
Administrator
(1)
Databases
(1)
script
(1)
Permissions
(4)
Audit
(1)
DDL
(1)
scripting
(1)
SQL Server 7, 2000
(4)
Authentication
(1)
Extended Stored Procedures
(1)
SID
(1)
T-SQL
(4)
Backup
(1)
Guest User
(1)
sp_msforeachdb
(1)
Role
(3)
Backup / Restore
(1)
Maintenance
(1)
User
(1)
GRANT
(2)
change db owner
(1)
Search for
any
content tagged
Security
Add a script
Items 1 to 20 of 27
Next 20 >>
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
2009/08/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,697 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
|
421 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
|
527 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
2009/04/16
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
6,240 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
|
905 reads
How to Change all Table owner one in to another in sql server 2000?
we need change all user table db owners For selected database using T SQL we can easily use this method.
Read more...
By
Tharindu Dhaneenja
2008/12/29
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
761 reads
Extract User-Role Mapping
This short script will list all the users along with their Roles.
Read more...
By
Sudhir Chawla
2008/12/23
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,483 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
|
Source:
SQLServerCentral.com
|
Category:
Permissions
Rating:
|
Discuss
|
Briefcase
|
6,925 reads
Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
Read more...
By
Rudy Panigas
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
880 reads
Grant permissions to objects
Grant permissions
Read more...
By
Sean K
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
128 reads
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
shivaram challa
2008/10/02
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
5,042 reads
Create Role for specific set of Objects based on a set of Conditions.
This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
Read more...
By
shivaram challa
2008/10/08
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
726 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:
|
Discuss
|
Briefcase
|
1,282 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
|
672 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
|
931 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
|
1,566 reads
usp_SecurCreation - SQL 2k5
Creates statements for securables creation.
Read more...
By
Pedro Lopes-389536
2008/06/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,569 reads
usp_SecurCreation - SQL 2k
Creates statements for securables creation.
Read more...
By
Pedro Lopes-389536
2008/06/26
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
781 reads
usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes-389536
2008/07/16
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,444 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
|
1,517 reads
Items 1 to 20 of 27
Next 20 >>
Most popular
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
2009/04/16
|
Source:
SQLServerCentral.com
|
Category:
Security
Rating:
|
Discuss
|
Briefcase
|
6,240 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
|
Source:
SQLServerCentral.com
|
Category:
Permissions
Rating:
|
Discuss
|
Briefcase
|
6,925 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
2009/08/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,697 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use