HP 3000 Manuals HP 3000 Manuals
Adding Turbo CONNECT Users: Task 3
This task describes how to add Turbo CONNECT users.
Getting Ready
The DBC is the only Turbo CONNECT user defined when a database is
attached. All other Turbo CONNECT users must be explicitly added. To
perform this task, you must be the TurboIMAGE/XL DBC and an ALLBASE/SQL
DBA. If you wish to check the current users before adding new Turbo
CONNECT 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 a Turbo CONNECT user. Until additional
Turbo CONNECT users are added, only the DBC can use Turbo CONNECT.
Performing the Task
Add Turbo CONNECT users with the ADD USER command. The 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 (see
Task Reference) and maps this ALLBASE/SQL DBEUserID to TurboIMAGE/XL
password CLERK which is associated with user class 14 in the
TurboIMAGE/XL schema:
______________________________________________________________________________
| |
| >>ADD USER SMITH@ATC WITH PASS=CLERK, MODE=6 |
| |
| Warning: command containing a password has been logged (ATCWARN 32069)|
| 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 password CLERK. 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
Turbo CONNECT user defined in the ATCINFO file.
* The ALLBASE/SQL syntax, User@Account, is used to add a Turbo CONNECT
user. This name, referred to as the DBEUserID, is made up of an MPE
XL user and account name, connected with the @ symbol. 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.
* Because Turbo CONNECT provides read-only access, it supports DBOPEN
modes 5, 6, 7, and 8. Mode 5 is the default. Refer to the
TurboIMAGE/XL Database Management System Reference Manual for more
information about DBOPEN modes.