ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 489
SQL Statements E - R
REVOKE
REVOKE
The REVOKE statement takes away authority that was previously granted by means of the
GRANT statement.The following forms of the REVOKE statement are described individually:
• Revoke table or view authority.
• Revoke RUN or EXECUTE authority.
• Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE authority.
• Revoke SECTIONSPACE or TABLESPACE authority for a DBEFileSet.
For detailed information about security schemes, refer to the "DBEnvironment
Configuration and Security" chapter of the ALLBASE/SQL Database Administration
Guide.
Scope
ISQL or Application Programs
SQL Syntax — Revoke Table or View Authority
REVOKE {ALL [PRIVILEGES]
[SELECT
INSERT
DELETE
ALTER
INDEX
UPDATE [({ ColumnName }[,...])]
REFERENCES [({ ColumnName }[,...])]]|,...|}
ON {[ Owner. ] TableName
[ Owner. } ViewName } FROM { DBEUserID
GroupName
ClassName
PUBLIC }[,...][CASCADE]
Parameters — Revoke Table or View Authority
ALL [PRIVILEGES] is the same as specifying the SELECT, INSERT, DELETE, ALTER,
INDEX, UPDATE, and REFERENCES options all at one time. The word
PRIVILEGES is not required; you can include it if you wish to improve
readability. ALTER, INDEX, and REFERENCES are not applied when
using REVOKE ALL on views.
SELECT revokes authority to retrieve data.
INSERT revokes authority to insert rows.
DELETE revokes authority to delete rows.
ALTER revokes authority to add new columns.
INDEX revokes authority to create and drop indexes.