ALLBASE/SQL Reference Manual (36216-90216)

204 Chapter6
Names
Authorization Names
Authorization Names
An authorization name identifies an owner name defined in the AUTHORIZATION
clause of the CREATE SCHEMA statement. Authorization names must be unique within the
DBEnvironment. There cannot be another owner, authorization group, or grantor with the
same name on the system when the CREATE SCHEMA statement is issued.
Authorization names can be one of the following:
• DBEUserID
• Group name
• Class name
Compound Identifiers
Basic names and DBEUserIDs are considered simple names. In some cases, simple
names are combined to form a compound identifier, which consists of an owner name
combined with one or more basic names, with periods (.) between them.
Often you can abbreviate a compound identifier by omitting one of its parts. If you do this,
a default value is automatically used in place of the missing part. For example, you can
omit the owner name (and the period) when you refer to tables you own; ALLBASE/SQL
generates the owner name by using your logon name.
A complete compound identifier, including all of its parts, is called a fully qualified
name. The following are compound identifiers:
Authorization group identifier—[
Owner .] GroupName
Column identifier— [ [ Owner .] TableName .] ColumnName
Constraint identifier— [ Owner .] ConstraintName
Index identifier— [ Owner .] IndexName
Module identifier—[ Owner .] ModuleName
Procedure identifier— [ Owner .] ProcedureName
Rule identifier—[ Owner .] RuleName
Section identifier— [ Owner .] ModuleName ( SectionNumber )
Table identifier— [
Owner .] TableName
View identifier— [ Owner .] ViewName
Different owners can have modules, tables, or views by the same name; the fully qualified
name of these objects must be unique in the DBEnvironment. Group names, however,
must be unique in the DBEnvironment.