SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-317
Syntax Description of REVOKE
(column [,column]...)
names the columns of the object to which the UPDATE or REFERENCES
privilege applies. If you specify UPDATE or REFERENCES without column
names, the privileges apply to all columns of the table or view.
ON [TABLE | SEQUENCE] object
specifies a table, sequence generator or view on which to revoke privileges. When
the object is a stored procedure, the only privilege that you can specify is ALL
PRIVILEGES. See REVOKE EXECUTE Statement on page 2-322 to revoke
privileges for stored procedures.
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 (for example, sql.user1) or
Guardian user number(for example, 255,255). authid is not case-sensitive.
SQL:1999 specifies two special authorization IDs: PUBLIC and SYSTEM.
•
PUBLIC specifies all present and future authorization IDs.
•
SYSTEM specifies the implicit grantor of privileges to the creators of objects.
You cannot specify SYSTEM as an authid in a REVOKE statement.
drop-behavior
If you specify RESTRICT, the REVOKE operation fails if there are privilege
descriptors or objects that would no longer be valid after the specified
privileges are removed.
If you specify CASCADE, any such dependent privilege descriptors and
objects are removed as part of the REVOKE operation.
The default is RESTRICT.
BY authid-grantor
specifies the authorization ID authid-grantor on whose behalf the revoke
operation is performed. Only the Super ID or a Security Administrator can use the
BY clause unless the Security Administrators Group is not empty and the Super ID
has not been designated as a Security Administrator in which case the Super ID is
REFERENCES Can create constraints that reference the object.
USAGE Can use the pseudocolumns, CURRVAL and NEXTVAL to
access the sequence generator values.
ALL PRIVILEGES Can have all privileges that apply to the object type.