Neoview SQL Reference Manual (R2.5)

REVOKE EXECUTE Statement
• “Syntax Description of REVOKE EXECUTE”
• “Considerations for REVOKE EXECUTE”
• “Examples of REVOKE EXECUTE”
The REVOKE EXECUTE statement removes privileges for executing a stored procedure in Java
(SPJ) from one or more specified roles. See “Privileges” (page 301).
REVOKE [GRANT OPTION FOR]
EXECUTE
ON [PROCEDURE] procedure-ref
FROM {grantee [,grantee ]... }
[RESTRICT | CASCADE]
procedure-ref is:
[schema-name.]procedure-name
grantee is:
authid
Syntax Description of REVOKE EXECUTE
GRANT OPTION FOR
specifies that the WITH GRANT OPTION for the EXECUTE privilege is to be revoked. The
EXECUTE privilege itself is not revoked.
EXECUTE
specifies the privilege of executing the specified stored procedure to be revoked.
ON [PROCEDURE] procedure-ref
specifies the name of a stored procedure on which to revoke privileges, of the form:
[schema-name.]procedure-name
where each part of the name is a valid SQL identifier with a maximum of 128 characters. For
more information, see “Identifiers” (page 269).
FROM {grantee [,grantee]... }
specifies one or more roles from whom you revoke privileges.
grantee is authid
authid specifies an authorization ID to whom you revoke privileges. Authorization IDs
identify roles during the processing of SQL statements. The authorization ID must be a valid
role name enclosed in double quotes. authid is not case-sensitive.
REVOKE EXECUTE allows two special authorization IDs called PUBLIC and SCHEMA:
• PUBLIC grants the privilege to all present and future authorization IDs.
• SYSTEM specifies the implicit grantor of privileges to the creator of objects. You cannot
specify SYSTEM as authid in a REVOKE EXECUTE statement.
[ RESTRICT | CASCADE ]
If you specify RESTRICT, the REVOKE operation fails if there are privilege descriptors that
would no longer be valid after the EXECUTE privilege is removed.
If you specify CASCADE, any such dependent privilege descriptors are removed as part of
the REVOKE EXECUTE operation.
The default is RESTRICT.
158 SQL Statements