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

Content with tags Security, GRANT, Permissions Rss

   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 | 735 reads

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,818 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,963 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,250 reads
   Items 1 to 4 of 4   
 
Tags
administration (1)    
database object permissions (1)    
databases (1)    
deny (1)    
logins (1)    
role (1)    
roles (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
t-sql (1)    
user (1)