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

Content with tags Security, GRANT Rss

   Items 1 to 9 of 9   

Column Level Permissions and DENY

By Steve Jones 2016/06/20 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,246 reads

Grant > Deny?

By Steve Jones 2016/05/23 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,373 reads

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

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,869 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,949 reads

Granting Permission to Grant Permissions

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...  Read more...
By Steve Jones 2013/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,407 reads

Grant Execute to all SQL Server Stored Procedures

With SQL Server 2000 no default server, database or application role was available to be able to execute all stored procedures. With SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 has this changed with all of the new security features? If not, what options do I have to grant execute rights to the needed database roles?  Read more...
By Additional Articles 2012/04/19 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,384 reads

Grant Execute Permissions to Stored Procedures using DDL Triggers

In your development environment if you have locked down permissions for developers, but still need them to execute stored procedures you will need to grant execute rights each time a new stored procedure is generated. In this tip I will show you a way of doing this automatically each time a new stored procedure is created without granting your developers additional permissions.  Read more...
By Additional Articles 2009/11/13 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,383 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
   Items 1 to 9 of 9   
permissions (5)    
deny (3)    
administration (1)    
blogs (1)    
database object permissions (1)    
databases (1)    
logins (1)    
role (1)    
roles (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
t-sql (1)    
user (1)