SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-169
REVOKE EXECUTE Statement
REVOKE EXECUTE Statement
Considerations for REVOKE EXECUTE
Examples of REVOKE EXECUTE
The REVOKE EXECUTE statement removes privileges for calling a stored procedure
in Java (SPJ) from one or more specified users.
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 calling the specified stored procedure.
ON [PROCEDURE] procedure-ref
specifies the ANSI logical name of a stored procedure on which to revoke
privileges, of the form:
[[catalog-name.]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 on page 6-52.
FROM {authid [,authid ]... | PUBLIC}
specifies one or more users from whom you revoke privileges.
authid specifies an authorization ID from whom you revoke privileges.
Authorization IDs identify users during the processing of SQL statements. The
authorization ID must be a valid Guardian user name, enclosed in double quotes.
A Guardian user number (for example, '255,255') is not allowed. authid is not
case-sensitive.
SQL:1999 specifies two special authorization IDs: PUBLIC and SYSTEM.
•
PUBLIC specifies all present and future authorization IDs.
REVOKE [GRANT OPTION FOR]
EXECUTE
ON [PROCEDURE] procedure-ref
FROM {grantee [,grantee]...} [RESTRICT | CASCADE]
[BY authid-grantor]
procedure-ref is:
[[catalog-name.]schema-name.]procedure-name
grantee is:
authid | PUBLIC