HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 4 IMAGE/SQL Utility Commands

UPDATE USER

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

Updates an IMAGE/SQL user's class number, password, and/or DBOPEN mode in a DBEnvironment.

Syntax

U[PDATE] USER { User@Acct User.Acct } TO { PASS=Password MODE=ModeNumber CLASS=ClassNumber } |,...|

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. You must specify CLASS, PASS, or MODE 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 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

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.

   >>
Feedback to webmaster