Column Level Permissions and DENY

Grant > Deny?

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.

View My Definition

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...

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?

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.

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.

RE: Backup strategy for replication

If the aim is for the central office to be able to view / report on the branch data, you might want to have a look at SQL Server's Transactional Replication. There are  a number of queueing options with it, that would allow the the branches to update the central server when they can get […]