 |
» |
|
|
|
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 logon 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@THOMAS, GEORGE@CRAMMER TO GROUP Warehse
|
Clem will no longer have any of the authorities associated with group Warehse.
REMOVE CLEM@THOMAS 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. |
