SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag GRANT Rss

Search for any content tagged grant

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 4 of 4   

Find Deny permissions on database objects

This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.  Read more...
Rating: |  Discuss |   Briefcase | 918 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,302 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 13,926 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,598 reads
   Items 1 to 4 of 4