SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-231
REVOKE Statement
REVOKE Statement
Considerations for REVOKE
Examples of REVOKE
The REVOKE statement revokes access privileges for an SQL/MX table, view, or
stored procedure from specified users. See also REVOKE EXECUTE Statement on
page 2-236
Syntax Description of REVOKE
GRANT OPTION FOR
specifies that the WITH GRANT OPTION for the specified privilege is to 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. See also REVOKE EXECUTE Statement
on
page 2-236.
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ]... | ALL [PRIVILEGES]}
ON [TABLE] object
FROM {grantee [,grantee]...} [drop-behavior]
[BY authid-grantor]
grantee is:
authid | PUBLIC
privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [(column [,column]...)]
| REFERENCES [(column [,column]...)]
drop-behavior is:
CASCADE | RESTRICT
SELECT Can use SELECT statement.
DELETE Can use DELETE statement.
INSERT Can use INSERT statement.