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-316
REVOKE Statement
REVOKE Statement
Considerations for REVOKE
Examples of REVOKE
The REVOKE statement revokes access privileges for an SQL/MX table, view,
sequence generator, or stored procedure from specified users. For more information,
see REVOKE EXECUTE Statement on page 2-322.
Syntax Description of REVOKE
GRANT OPTION FOR
specifies that the WITH GRANT OPTION for the privilege must be revoked. The
privilege itself is not revoked.
privilege [,privilege]... | ALL [PRIVILEGES]
specifies the privileges to revoke, as follows. You can specify each of these
privileges for a table or view. For a stored procedure, ALL PRIVILEGES revokes
only the EXECUTE privilege. For a sequence generator, ALL PRIVILEGES
revokes only the USAGE privilege. See also REVOKE EXECUTE Statement on
page 2-322.
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ]... | ALL [PRIVILEGES]}
ON [TABLE | SEQUENCE ] object
FROM {grantee [,grantee]...} [drop-behavior]
[BY authid-grantor]
grantee is:
authid | PUBLIC
privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [(column [,column]...)]
| REFERENCES [(column [,column]...)]
| USAGE
drop-behavior is:
CASCADE | RESTRICT
SELECT Can use SELECT statement.
DELETE Can use DELETE statement.
INSERT Can use INSERT statement.
UPDATE Can use UPDATE statement.