SQL Server Central is supported by Red Gate Software Ltd.
 
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 Rss

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