HP 3000 Manuals HP 3000 Manuals
Adding IMAGE/SQL Users: Task 3
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 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 IMAGE/SQL user defined in the ATCINFO file.
* 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 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.
[REV BEG]
* IMAGE/SQL supports all DBOPEN modes.[REV END] Mode 5 is the
default. Refer to the TurboIMAGE/XL Database Management System
Reference Manual for more information about DBOPEN modes.