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

Content with tags Security, GRANT Rss

   Items 1 to 7 of 7   

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

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,845 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: | Category: permissions
Rating: |  Discuss |   Briefcase | 13,593 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: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,504 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: | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,197 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: | Category: security
Rating:  Rate this |   Briefcase | 3,122 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: | Category: security
Rating: |  Discuss |   Briefcase | 1,266 reads
   Items 1 to 7 of 7   
permissions (4)    
administration (1)    
blogs (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)