HP 3000 Manuals HP 3000 Manuals
UPDATE USER
[REV BEG]
Updates an IMAGE/SQL user's class number, password, and/or DBOPEN mode in
a DBEnvironment.
Syntax
{PASS=Password }
U[PDATE] USER {User@Acct} TO {MODE=ModeNumber } |,...|
{User.Acct} {CLASS=ClassNumber}
[REV END]
Parameters
User@Acct is the name used to identify the user in the DBEnvironment.
This name, referred to as the DBEUserID, is made up of the
MPE/XL user and account name, connected with the period or
@ symbol.
Password is a password in the TurboIMAGE/XL schema. The new
IMAGE/SQL user has the same access to the TurboIMAGE/XL
data as the user class associated with this password.[REV
BEG] You must specify CLASS, PASS, or MODE parameter.[REV
END]
ModeNumber is the DBOPEN mode with which the database is opened for
this user. You must specify this parameter and/or the
ClassNumber parameter. Valid DBOPEN modes are 1 through 8.
If this parameter is omitted, the mode defaults to 5.
ClassNumber is the user class number.
Prerequisites
* SET SQLDBE issued.
* SET TURBODB issued.
* DBC required.
* DBA authority.
* Database attached.
Description
Use the UPDATE USER command to update user information stored in the
ATCINFO file. Information about the user password and the user's DBOPEN
mode can be updated.
When a user password is updated, the associated DBEUserID (User@Account)
is automatically deleted from the old group and added to a new group
whose name is derived from the new user class given in the command. (For
example, the password corresponding to user class 12 produces a group
named OwnerName_12.) If this group does not exist, it is created.
To enforce TurboIMAGE/XL security, views are created for this group.
These views limit this group's access to those data sets and data items
defined for the corresponding user class/password in the TurboIMAGE/XL
database schema.
Example
[REV BEG]
In the following example, user RYAN.ATC is updated to DBOPEN mode 1 with
user class 13.
________________________________________________
| |
| UPDATE USER RYAN.ATC TO MODE=1, CLASS=13|
| |
| ALLBASE/SQL group SALES_13 created. |
| View SALES.DATE_MASTER_V13 created. |
| View SALES.DATE_PRODUCT_V13 created. |
| View SALES.DATE_VENDOR_V13 created. |
| View SALES.DATE_INVENTORY_V13 created. |
| >> |
| |
________________________________________________
[REV END]