HP 3000 Manuals HP 3000 Manuals
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.[REV
BEG] It maps this ALLBASE/SQL DBEUserID to the user class 14 which is
associated with password, CLERK, in the TurboIMAGE/XL schema.[REV END]
[REV BEG]
_________________________________________________
| |
| >>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. |
| >> |
_________________________________________________
[REV END][REV BEG]
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.[REV
END] 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.