ALLBASE/SQL Reference Manual (36216-90216)

438 Chapter11
SQL Statements E - R
GRANT
Parameters — Grant RUN or EXECUTE Authority
RUN grants authority to execute a specified module created interactively or by
using a preprocessor.
[
Owner .] ModuleName specifies the name of the module for which authority is to be
granted.
EXECUTE grants authority to execute a specified procedure.
[
Owner .] ProcedureName specifies the name of the procedure for which authority is to be
granted.
TO The TO clause tells which users and authorization groups are to be
granted the specified authority. You must specify a login name when
specifying a DBEUserID. Authority granted to PUBLIC can be exercised
by any user with CONNECT authority.
Authorization — Grant RUN or EXECUTE Authority
If you have DBA authority or OWNER authority, you can issue GRANT statements for any
module or procedure.
To grant CONNECT, DBA, or RESOURCE authority, you must have DBA authority.
SQL Syntax — Grant CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
GRANT {CONNECT
DBA
INSTALL [AS OwnerID ]
MONITOR
RESOURCE }TO { DBEUserID
GroupName
ClassName } [,...]
Parameters — Grant CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
CONNECT grants authority to use the CONNECT statement.
DBA grants authority to issue any valid ALLBASE/SQL statement. A user with
DBA authority is exempt from all authorization restrictions.
RESOURCE grants authority to create tables and authorization groups.
MONITOR grants authority to run SQLMON.
INSTALL grants authority to INSTALL modules where the owner name equals the
OwnerID . If the "AS OwnerID " clause is omitted, then grants 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