CREATE GROUP

Scope

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

Example

   CREATE GROUP Warehse

   GRANT CONNECT TO Warehse

   GRANT SELECT,
         UPDATE (BinNumber,QtyOnHand,LastCountDate)
      ON PurchDB.Inventory
      TO Warehse

   ADD Clem, George TO GROUP Warehse

   REMOVE Clem FROM GROUP Warehse

   DROP GROUP Warehse