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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-167
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] object
specifies a table 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-169 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, 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.
•
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. The privileges being revoked must have been previously
granted by authid-grantor. Only the super ID can use the BY clause. If another
user attempts to do so, the system returns an error. The effect of using the BY
UPDATE Can use UPDATE statement.
REFERENCES Can create constraints that reference the object.
ALL PRIVILEGES Can have all privileges that apply to the object type.