ALLBASE/SQL Reference Manual (36216-90216)

490 Chapter11
SQL Statements E - R
REVOKE
UPDATE revokes authority to change data in existing rows. A list of column names
can be specified to revoke UPDATE authority for only those columns if the
columns were named in a GRANT statement UPDATE clause. Omitting the
list of column names revokes authority to update all columns.
REFERENCES revokes authority to reference columns in the table from foreign keys in
another table. A list of column names can be specified to revoke
REFERENCES authority for only those columns if the columns were
named in a GRANT statement REFERENCES clause. Omitting the list of
column names revokes REFERENCES authority on all columns.
[
Owner .] TableName designates the table for which authority is to be revoked.
[
Owner .] ViewName designates the view for which authority is to be revoked.
FROM The FROM clause designates the users, authorization groups, and classes
whose authority is to be revoked. PUBLIC is specified to revoke authority
previously granted to PUBLIC. You cannot revoke table or view
authorities from the current owner of a table or view.
CASCADE If the revoked privilege was grantable (granted with the WITH GRANT
OPTION clause), then any grants of the privilege by the revokee will also
be revoked. However, if a grantee is DBA or owner of an object, cascading
stops at that point for the grantee, and any grants and subsequent chains
issued by him or her are still in effect. CASCADE can be specified by any
user who can revoke authorities on the table or view.
If CASCADE is not specified and you are not DBA, you cannot revoke a
grantable privilege if it had been granted to another user (as this would
create an orphaned privilege). For more information on privileges, refer to
"Using the GRANT OPTION Clause" in the "Database Creation and
Security" chapter of the ALLBASE/SQL Database Administration Guide..
Description — Revoke Table or View Authority
• If a view relies on a SELECT authority on a table and the REVOKE with CASCADE
option is issued against that table, then the view is destroyed and a warning is
returned. If the CASCADE option is not specified, the view remains, but you will receive
authority errors when you try to use it.
• If a referential constraint relies on a REFERENCES privilege on a table, and the
REVOKE REFERENCES with the CASCADE option is issued against that table or
column in it, then that particular REFERENCES privilege is destroyed. This can
include any REFERENCES in the chain of privileges that are revoked in the
CASCADE. A warning is returned when a constraint is destroyed.
Authorization — Revoke Table or View Authority
If you are DBA, the owner, or the grantor of table privileges and still have that
grantability, you can issue the REVOKE statement and optionally the CASCADE option.