HP 3000 Manuals HP 3000 Manuals
UPDATE USER
Updates a Turbo CONNECT user's class number and/or DBOPEN mode in a
DBEnvironment.
Syntax
{PASS=Password }
U[PDATE] USER User@Acct TO {MODE=ModeNumber}
|,...|
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 user and account name, connected with the @ symbol.
Password is a password in the TurboIMAGE/XL schema. The new Turbo
CONNECT user has the same access to the TurboIMAGE/XL data
as the user class associated with this password. You must
specify this parameter and/or the ModeNumber parameter.
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 5, 6, 7, and
8. If this parameter is omitted, the mode defaults to 5.
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 also 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
In the following example, user RYAN@ATC is updated to DBOPEN mode 7 with
password "dockhand".
_____________________________________________________________
| |
| UPDATE USER RYAN@ATC TO MODE=7, PASSWORD=dockhand |
| Warning: command containing a password has been logged|
| (ATCWARN 32069). |
| 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. |
| >> |
| |
_____________________________________________________________