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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-166

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-169

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-169.

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.