Revoking EXECUTE Privileges
From InterBase
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;