tags:

views:

732

answers:

3

If I grant execute permissions to a role via

GRANT EXECUTE ON [DBO].[MYPROC] TO MY_ROLE

what's the equivalent syntax to remove them?

A: 

REVOKE EXECUTE ON [DBO].[MYPROC] TO MY_ROLE

mathieu
+2  A: 
DENY EXECUTE ON [DBO].[MYPROC] TO MY_ROLE

or

REVOKE EXECUTE ON [DBO].[MYPROC] TO MY_ROLE

depending on your goal. The first acts as a filter for any granted permissions, the second removes an explict permission.

Godeke
A: 
DENY EXECUTE ON [DBO].[MYPROC] TO MY_ROLE
Marcus King