Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Permissions Rss

Search for any content tagged permissions

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 14 of 14   
 

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,838 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,277 reads

Reverse-Engineer Database Permissions (2005 up)

This script reverse engineers SQL statements to recreate database permissions.  Read more...
By george sibbald 2011/10/24 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 2,760 reads

Retrieve Database Object permission scripts and Role members scripts

I often need to synchronize the user permission between databases. I wrote this simple query to script the sql statement to per item.   Read more...
By Gokhan Varol 2011/02/03 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 2,631 reads

Stored procedure to script out user permissions

Stored procedure to script out user permissions  Read more...
By Harsha Majety 2011/01/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 4,485 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,655 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 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,584 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,232 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,510 reads

Change Ownership of a Maintenance Plan

Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.   Read more...
By Phill Carter 2008/12/12 | Source: SQLServerCentral.com | Category: ownership
Rating: |  Discuss |   Briefcase | 2,915 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,643 reads

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.  Read more...
By Mani Singh 2008/08/01 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 2,520 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh 2008/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,683 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By stumbling fish 2011/12/12 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 3,766 reads
   Items 1 to 14 of 14