 |
» |
|
|
|
The CREATE GROUP statement defines a new authorization group. Scope | |
ISQL or Application Programs SQL Syntax | |
CREATE GROUP [Owner.]GroupName |
Parameters | |
- [Owner.]GroupName
specifies the group name to be assigned to the new
authorization group. The group name must conform to the syntax rules
for basic names, described in the "Names" chapter. You can specify the owner of the new group if you have
DBA authority. Non-DBA users can specify as owner the name of any
group of which they are a member. If you do not specify the owner
name, your login name becomes the owner of the new group. Although the owner name can be specified as a prefix to the
group name in this statement, the owner name is not actually considered
a part of the group identifier. The group name by itself uniquely
identifies a group within the database. The group name you specify cannot be the same as any of the
following names: Name
of an existing authorization group. Owner name of an existing table, view, module, or
authorization group. DBEUserID existing in the authorization tables of
the system catalog. DBEUserID associated with any DBE session currently
in progress. Special names PUBLIC, SYSTEM, CATALOG, HPRDBSS, STOREDSECT,
SEMIPERM, HPODBSS, and TEMP.
Description | |
When you create an authorization group,
its owner name and group name are entered into the system catalog.
You can then refer to the group in the ADD TO GROUP, REMOVE FROM GROUP, GRANT, REVOKE, TRANSFER OWNERSHIP, and DROP GROUP statements.
Authorization | |
You must have RESOURCE or DBA authority to use this statement. Example | |
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 will no longer have 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. |
