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

Content with tag GRANT Rss

   Items 1 to 7 of 7   
 

View My Definition

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

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 | 1,303 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 | 1,978 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,034 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

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
   Items 1 to 7 of 7   
 
Tags
security (6)    
permissions (4)    
administration (2)    
t-sql (2)    
administrator (1)    
blogs (1)    
databases (1)    
logins (1)    
object permissions (1)    
role (1)    
roles (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
user (1)