This task describes how to add IMAGE/SQL users.
Getting Ready
The DBC is the only IMAGE/SQL user defined when a database is attached.
All other IMAGE/SQL users must be explicitly added.
To perform this task,
you must be the TurboIMAGE/XL DBC and the ALLBASE/SQL DBA.
If you want to check the current users before adding new IMAGE/SQL users,
issue the DISPLAY USER command. For example:
>>DISPLAY USER
TurboIMAGE/XL DB : SALES.SERED.ATC
DBEnvironment : PARTSDBE.SERED.ATC
USER LOGON DBOPEN MODE USER PASSWORD USER CLASS
---------- ----------- ------------- ----------
NANCY.ATC 5 ; 64
>>
|
Here, only the DBC is defined as an IMAGE/SQL user. Until additional IMAGE/SQL users
are added, only the DBC can use IMAGE/SQL.
Performing the Task
Add IMAGE/SQL users with the ADD USER command.
The class or password specified for the new user in this command must exist in the TurboIMAGE/XL database schema.
The following example adds the user SMITH.ATC to the DBEnvironment.
It maps this ALLBASE/SQL DBEUserID to the user class 14 which is
associated with password, CLERK, in the TurboIMAGE/XL schema.
>>ADD USER SMITH.ATC WITH CLASS=14, MODE=6
ALLBASE/SQL group SALES_14 created.
View SALES.DATE_MASTER_V14 created.
View SALES.CUSTOMER_V14 created.
View SALES.PRODUCT_V14 created.
View SALES.INVENTORY_V14 created.
View SALES.SALES_V14 created.
>>
|
The creation of these views allows SMITH.ATC to read only the data that is
specified in the TurboIMAGE/XL schema for class 14 or password CLERK.
The ADD USER command will accept the CLASS option or the PASS option.
This user has DBOPEN mode 6 access to the database.
The DISPLAY USER command now reflects the added user:
>>DISPLAY USER
TurboIMAGE/XL DB : SALES.SERED.ATC
DBEnvironment : PARTSDBE.SERED.ATC
USER LOGON DBOPEN MODE USER PASSWORD USER CLASS
---------- ----------- ------------- ----------
NANCY.ATC 5 ; 64
SMITH.ATC 6 CLERK 14
>>
|
Task Reference
At attach time, the TurboIMAGE/XL database creator (DBC) is the
only IMAGE/SQL user defined in
the ATCINFO file (DBEnvironmentNameCR).
The ALLBASE/SQL syntax User@Account is used to add an IMAGE/SQL user.
This name, referred to as the DBEUserID, is made up of an MPE/iX
user and account name, connected with the @ symbol (or period). It must
contain valid logon syntax.
The ADD USER command maps the corresponding TurboIMAGE/XL user class to
an ALLBASE/SQL group.
The name of the new ALLBASE/SQL authorization group is Ownername_nn, where
nn
is the TurboIMAGE/XL user class number.
To map the data set and data item security defined for the user class in the
source TurboIMAGE/XL database
schema,
ALLBASE/SQL views are created for each new group.
The name of these views is MappedTableName_Vnn, where nn is the
TurboIMAGE/XL user class number.
One view is created for each
mapped table the authorization group is allowed to read. Each view contains
only those
mapped columns to which the authorization group (user class) is allowed access.
IMAGE/SQL supports all DBOPEN modes.
Mode 5 is the default. Refer to the TurboIMAGE/XL Database Management System Reference Manual for more information about
DBOPEN modes.