ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 491
SQL Statements E - R
REVOKE
SQL Syntax — Revoke RUN or EXECUTE or Authority
REVOKE [RUN ON [ Owner. ] ModuleName
EXECUTE ON PROCEDURE [ Owner. ] ProcedureName ] FROM
{{ DBEUserID
GroupName
ClassName }[,...]
PUBLIC }
Parameters--Revoke RUN or EXECUTE Authority
RUN revokes authority to access the DBEnvironment using the specified
module.
[
Owner .] ModuleName specifies the module for which RUN authority is to be revoked.
EXECUTE revokes authority to execute the specified procedure.
[
Owner .] ProcedureName specifies the procedure for which EXECUTE authority is to be
revoked.
FROM The FROM clause lists the users, authorization groups, and classes that
were previously granted the authority that is now to be revoked. PUBLIC
can be specified to revoke authority that was previously granted to
PUBLIC.
SQL Syntax — Revoke CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
REVOKE {CONNECT
DBA
INSTALL [AS OwnerID ]
MONITOR
RESOURCE }FROM { DBEUserID
GroupName
ClassName }[,...]
Parameters — Revoke CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
CONNECT revokes authority to use the CONNECT statement.
DBA revokes the authority which exempts a user from all authorization
restrictions. You can never revoke DBA authority from the DBECreator.
INSTALL revokes authority to INSTALL modules where the owner name equals
OwnerID . If the "AS OwnerID " clause is omitted, then revokes authority to
INSTALL modules having any owner name.
Modules for an application are created and installed when that application
is preprocessed using one of the SQL preprocessors. Modules can also be
installed by using the ISQL INSTALL command. See the ALLBASE/ISQL
Reference Manual for more details.
MONITOR revokes authority to run SQLMON.