ALLBASE/SQL Reference Manual (36216-90216)

332 Chapter10
SQL Statements A - D
CREATE GROUP
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 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.