HP 3000 Manuals HP 3000 Manuals
UPDATE USER
Updates an IMAGE/SQL user's class number and/or DBOPEN mode in a
DBEnvironment.
Syntax
U[PDATE] USER User@Acct TO {PASS=Password } |,...|
{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/XL user and account name, connected with the @ 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. 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.[REV BEG] Valid DBOPEN modes are 1
through 8.[REV END] 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 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[REV BEG] DBOPEN
mode 1 with password "dockhand".[REV END][REV BEG]
______________________________________________________________________________
| |
| UPDATE USER RYAN@ATC TO MODE=1, 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. |
| >> |
| |
______________________________________________________________________________
[REV END]