ALLBASE/SQL Reference Manual (36216-90216)

492 Chapter11
SQL Statements E - R
REVOKE
RESOURCE revokes authority to create tables and authorization groups.
FROM The FROM clause specifies the users, authorization groups, and classes
whose authority is to be revoked.
Description — Revoke CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
• The REVOKE statement may invalidate stored sections. Refer to the VALIDATE
statement and to the ALLBASE/SQL Database Administration Guide for additional
information on the validation of stored sections.
• Issue a REVOKE INSTALL FROM
DBEUserID statement that omits the "AS OwnerID "
clause to remove all INSTALL authorities for a particular user.
Authorization — Revoke CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
If you have OWNER or DBA authority for a module, you can issue REVOKE statements for
that module.
SQL Syntax — Revoke DBEFileSet Authority
REVOKE {SECTIONSPACE
TABLESPACE } |,...| ON DBEFILESET DBEFileSetName FROM
{ { DBEUserID
GroupName
ClassName }[,...]
PUBLIC }
Parameters — Revoke DBEFileSet Authority
SECTIONSPACE revokes authority to store sections in the specified DBEFileSet.
TABLESPACE revokes authority to store table and long column data in the specified
DBEFileSet.
DBEFileSetName designates the DBEFileSet for which authority is to be revoked.
Description — Revoke DBEFileSet Authority
• In order for the statement to complete successfully, the authority being revoked must
have been previously granted to the specific user. In addition, the DBEFileSet cannot be
the current default for that user.
• When SECTIONSPACE authority is revoked, current stored section information for the
DBEFileSet remains (and thus any section revalidation continues to use that
DBEFileSet). No new sections for the user(s) whose authority was revoked can be
placed there.
• When TABLESPACE authority is revoked, table and long column data currently in the
DBEFileSet remain there. No new tables or long columns for the user(s) whose
authority was revoked can be place there.