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;