Task 3: Adding IMAGE/SQL Users

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.

Task 3: Adding IMAGE/SQL Users

Technical documentation

» Table of Contents

» Glossary

» Index