Neoview SQL Reference Manual (R2.5)

REVOKE Statement
• “Syntax Description of REVOKE”
• “Considerations for REVOKE”
• “Examples of REVOKE”
The REVOKE statement revokes access privileges for a Neoview SQL table, view, or materialized
view from specified roles or through a synonym of a table, view, or materialized view. See
“Privileges” (page 301).
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ]...| ALL [PRIVILEGES]}
ON [TABLE] object
FROM {grantee [,grantee ]
}
[drop-behavior]
grantee is:
authid
privilege is:
DELETE
| INSERT
| REFERENCES [(column [,column]...)]
| SELECT
| UPDATE [(column [,column]...)]
drop-behavior is:
{ RESTRICT | CASCADE }
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. You can specify each of these privileges for a table, view,
or materialized view.
Revokes the ability to use the DELETE statement.DELETE
Revokes the ability to use the INSERT statement.INSERT
Cannot create constraints that reference the object.REFERENCES
Revokes the ability to use the SELECT statement.SELECT
Revokes the ability to use the UPDATE statement.UPDATE
Revokes the ability to use all privileges that apply to
the object type.
ALL PRIVILEGES
(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 revoke applies to
all columns of the table, view, or materialized view.
ON [TABLE]object
specifies a table, view, or materialized view on which to revoke privileges.
156 SQL Statements