ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 439
SQL Statements E - R
GRANT
Reference Manual for more details.
TO The TO clause specifies the users, authorization groups, and classes to be
given the specified authority. You must specify a login name when
specifying a DBEUserID. Granting DBA authority to a class is useful
when program modules are owned by a class.
Description — Grant CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
• If MONITOR authority is granted to a user, authorization group, or class that already
has DBA authority, a warning is returned and explicit MONITOR authority is not
granted since a DBA already has MONITOR authority.
• If DBA authority is granted to a user, authorization group, or class that already has
MONITOR authority, MONITOR authority is upgraded to DBA authority.
Authorization — Grant CONNECT, DBA, INSTALL, MONITOR, or
RESOURCE Authority
If you have OWNER authority for a table, view, or module, you can issue GRANT statements
for that table or view. If you have DBA authority, you can issue GRANT statements for any
table, view, or module. To grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE
authority, you must have DBA authority.
SQL Syntax — Grant DBEFileSet Authority
GRANT {SECTIONSPACE
TABLESPACE } [,...] ON DBEFILESET DBEFileSetName TO
{ DBEUserID
GroupName
ClassName
PUBLIC } [,...]
Parameters — Grant DBEFileSet Authority
SECTIONSPACE grants authority to store sections in the specified DBEFileSet.
A grant of SECTIONSPACE causes a check to see whether the
STOREDSECT table has yet been created for the DBEFileSet. If there is
no related STOREDSECT table, it is created.
When a user specifies a DBEFileSet for a section in a CREATE TABLE (check
constraints), ALTER TABLE (check constraints), CREATE PROCEDURE,
CREATE RULE, or PREPARE statement, in preprocessing, or in the ISQL
INSTALL command, the owner of the section is checked for
SECTIONSPACE authority on the DBEFileSet. If the user does not have
SECTIONSPACE authority, the default SECTIONSPACE DBEFileSet is
used instead. (See the SET DEFAULT DBEFILESET statement.) This applies
even if the user has DBA authority.
TABLESPACE grants authority to store table and long column data in the specified