HP 3000 Manuals

ALLBASE/SQL Reference Manual

CREATE GROUP 

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.

     DROP GROUP Warehse

MPE/iX 5.5 Documentation