ALLBASE/SQL Reference Manual (36216-90216)

440 Chapter11
SQL Statements E - R
GRANT
DBEFileSet.
When a user specifies the IN DBEFileSet clause in a CREATE TABLE
statement for either the table or for a LONG column, the owner of the
table is checked for TABLESPACE authority on the DBEFileSet. If the
user does not have TABLESPACE authority, the default TABLESPACE
DBEFileSet is used instead (See the SET DEFAULT DBEFILESET
statement.) This applies even if the user has DBA authority.
DBEFileSetName designates the DBEFileSet for which authority is to be granted.
Description
• The execution of this statement causes modification to the HPRDBSS.SPACEAUTH
system catalog table. Refer to the ALLBASE/SQL Database Administration Guice
"System Catalog" chapter.
Authorization — Grant DBEFilesSet Authority
To grant SECTIONSPACE or TABLESPACE, you must have DBA authority. If you have
DBA authority, you can issue the GRANT statement for any DBEFileSet.
Examples
1. Authorization groups
CREATE GROUP Warehse
GRANT CONNECT TO Warehse
GRANT SELECT,
UPDATE (BinNumber,QtyOnHand,LastCountDate)
ON PurchDB.Inventory
TO Warehse
These two users will be able to start DBE sessions for PartsDBE, retrieve data from
table PurchDB.Inventory, and update three columns in the table.
ADD Clem, George TO GROUP Warehse
Clem no longer has any of the authorities associated with group Warehse.
REMOVE Clem FROM GROUP Warehse
Because this group does not own any database objects, it can be deleted. George no
longer has any of the authorities once associated with the group.
DROP GROUP Warehse