Revoking EXECUTE Privileges

From InterBase
Jump to: navigation, search

Go Up to Revoking User Access


Use REVOKE to remove EXECUTE privileges on a stored procedure. The syntax for revoking EXECUTE privileges is as follows:

REVOKE EXECUTE ON PROCEDURE procname FROM {<object> | <userlist>}
<object> = {
 PROCEDURE procname
 | TRIGGER trigname
 | VIEW viewname
 | PUBLIC
 }
 [, <object> ]
<userlist> = [USER] username [, [USER] username ]

The following statement removes EXECUTE privilege for user EMIL on the MONEY_TRANSFER procedure:

REVOKE EXECUTE ON PROCEDURE MONEY_TRANSFER FROM EMIL;

Advance To: