HP 3000 Manuals

User Menu [ Information Access Server: Database Administration ] MPE/iX 5.0 Documentation

Information Access Server: Database Administration

User Menu

At the User Menu (U), the menu path you choose will let you add, change,
delete, or examine user definitions.

To handle user definitions:

* Go directly to the screen you want by typing its screen name in
the Go to screen field of any menu and pressing Enter, or

* Choose a function label at the User Menu (U).

The User Menu looks like this.
______________________________________________________________________________________________
| |
| |
| CONFIG User Menu Screen: U |
| Choose a function, or type in a screen name and press ENTER. |
| |
| |
| Add User - Add the definition of a user. |
| |
| Change User - Change the definition of a user. |
| |
| Delete User - Delete the definition of a user. |
| |
| Show One User - Show the password, access group, the maximum number of |
| tables and sectors, the priority queue, and the DBA |
| characteristics (if any) for one user. |
| |
| List All Users - List the users and their access groups |
| |
| Done - Return to the Configuration Main Menu. |
| |
| |
| Go to screen |
| |
| Add Change Delete Show One List All Done |
| User User User User Users |
| |
______________________________________________________________________________________________

Default Users

Access Server gives you the option of allowing nonconfigured users to see
public tables. Upon installation of Access Server, the access group
DEFAULT-GROUP and its only user DEFAULT-USER are defined in the data
dictionary. The access group has capability 1, and the user has no
saved-table capability.

If you don't want to allow default users, delete the access group
DEFAULT-GROUP using the Delete Access Group (DG) screen. The user
DEFAULT-USER will be deleted during this process as well.

If you want to give DEFAULT-USER saved-table capability, use the Change
User (CU) screen to modify the user definition accordingly.

Assigning Secondary DBA Capabilities

The primary DBA can give a user secondary DBA capabilities at the Add
User (AU) or Change User (CU) screens. This lets the secondary DBA do
the following:

* Control data sources (either created by self or transferred from
another DBA)
* Configure tables from data sources they control
* Configure users (but not other secondary DBAs)
* Configure access groups
* Transfer control of a data source to another DBA
* Synchronize tables they control
* Print reports showing the data sources and tables they control
* Specify an editor for adding and changing view tables

Adding a User Definition

Add the definition of a user to the data dictionary at the Add User (AU)
screen, shown on the next page.

Table 7-1 describes the fields in the Add User screen.

DBA Capabilities.

Table 7-1. Add User Screen Fields

--------------------------------------------------------------------------------------------
| | |
| Field | Definition |
| | |
--------------------------------------------------------------------------------------------
| | |
| User | Name assigned to the user. The name can be up to 16 characters long |
| | and must begin with an alpha character, followed by any combination |
| | of alphanumeric characters and/or hyphens. |
| | |
--------------------------------------------------------------------------------------------
| | |
| User Password | Access Server password assigned to the user. The password too can be |
| | up to 16 characters long and must begin with an alpha character, |
| | followed by any combination of alphanumeric characters and/or |
| | hyphens. The password is case-sensitive; it must be entered exactly |
| | as it was created. This field can be left blank if you don't want to |
| | assign a password. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Access Group | Access group this user belongs to. Each user is a member of one and |
| | only one access group. The access group must have been previously |
| | configured using the Add Access Group (AG) screen before it can be |
| | used here. |
| | |
--------------------------------------------------------------------------------------------

Table 7-1. Add User Screen Fields (cont.)

--------------------------------------------------------------------------------------------
| | |
| Field | Definition |
| | |
--------------------------------------------------------------------------------------------
| | |
| Max Tables Saved | Maximum number of result tables the user can save on the host HP |
| | 3000. The default is "no limit." |
| | |
--------------------------------------------------------------------------------------------
| | |
| Max Sectors Used | Maximum number of disc sectors the user can use to save result tables |
| | on the host HP 3000. The default is "no limit", though strictly |
| | speaking, the actual maximum if no limit is specified is |
| | 2,147,483,647. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Priority Queue | Server process's MPE priority, either CS, DS, or ES. The default is |
| | CS. |
| | |
--------------------------------------------------------------------------------------------
| | |
| DBA Capability | Secondary DBA capabilities are assigned to the user (primary DBA |
| | only). |
| | |
--------------------------------------------------------------------------------------------

To Add a User Definition:.

1. Go to the Add User screen by typing AU in the Go to screen field
of any menu, or by choosing Add User f1 at the User Menu.

2. Type in the user name, the user password (if any), the access
group you want to associate with this user, the limits (if any) on
the number of tables the user can save, the number of disc sectors
those saved tables can occupy, and the server's MPE priority (if
different from the default).

3. To specify secondary DBA capabilities, type any non-blank
character in the DBA Capability field.

4. To add the definition, press Enter.

The user definition is added to the data dictionary.

5. When the screen clears, you can add another user.

6. To leave this screen, choose Done f8. This returns you to the
User Menu. From there, you can go to another screen or exit the
utility.

Changing a User Definition

Change a user definition already in the data dictionary at the Change
User (CU) screen. This screen displays the current definition of the
user you specify, in the same format as the Add User screen.

You can change any field except the User name. (For information about
these fields, see "Adding a User Definition," above.)

To change the User name, you must delete the entry and add a new entry.
(See "Deleting a User Definition," below.)

If you remove secondary DBA capabilities from a user definition, that
user no longer controls any data sources and tables and cannot use the
Administrator Utility. As the primary DBA, you will have control of
their data sources and tables.

NOTE Before you remove secondary DBA capabilities from a user
definition, you might want to do the following:

Identify the data sources controlled by the secondary DBA by
running from the Report on Configuration screen the report options
that list all remote HP 3000 systems, all IMAGE databases, and all
files.

Change the controlling DBA for any data sources controlled by that
secondary DBA to either another secondary DBA or to yourself by
using the appropriate Change Controlling DBA screen. (Although you
will be controlling the data sources after removing the secondary
DBA's capabilities, using the Change Controlling DBA screen updates
reports and lists to show the current controller of a data source.)

DBA Capabilities.

If you are a secondary DBA, you can change only the user definitions that
you control.

Impact on PC Users.

Changes to the definition of a currently active user have the following
effects:

* A change in the user's password does not affect the current
session. The next time the user summons the Remote Tables screen
on the PC, or issues the USER or REMOTE commands in the Host Batch
Facility, the new password will be required.

* A change in the user's access group, likewise, does not affect the
current session, with one exception: If the user's previous
access group has capability level 2 or 3 and the user tries to
configure databases, or configure tables, or delete configured
tables, then Access Server checks the user's capabilities and the
altered user definition takes immediate effect. As a result, the
next time the user goes to the Remote Tables screen on the PC, or
issues the USER or REMOTE commands in the Host Batch Facility, the
new access group's tables will now appear in place of the old.

* A change in maximum tables saved or maximum sectors used takes
immediate effect. If the user currently exceeds either of the
limits, no tables the user has previously saved are lost. Any
further attempts to save tables, however, will be unsuccessful
until either you or the user has deleted a sufficient number of
saved tables to bring the numbers of tables and sectors below the
new limits.

* A change in the server's MPE priority does not affect the current
session. The next time the user runs Access PC and summons the
Remote Tables screen, or issues the USER or REMOTE commands in the
Host Batch Facility, the new MPE priority will take effect.

To Change a User Definition:.

1. Go to the Change User screen by typing CU in the Go to screen
field of any menu, or by choosing Change User f2 at the User
Menu.

2. Type the user name and press Enter.

If an entry exists for this user, the current definition is
displayed.

3. Type in any changes to the User Password, Access Group, Max Tables
Saved, Max Sectors Used, Priority Queue, and DBA Capability
fields.

If you decide to leave the user definition unchanged, choose
Cancel Changes f8. The screen will clear and you can specify
another user to change or return to the User Menu.

4. To put the changes into effect, press Enter.

The existing entry for the user is updated.

5. When the screen clears, you can change another user definition.

6. To leave this screen, choose Done f8. This returns you to the
User Menu. From there, you can go to another screen or exit the
utility.

Deleting a User Definition

Delete an unwanted user definition at the Delete User (DU) screen.

If you delete a user that has secondary DBA capabilities, all of that
user's data sources and tables are placed under your control.

NOTE Before you delete a user that has secondary DBA capabilities, you
might want to do the following:

Change the controlling DBA for any data sources controlled by that
secondary DBA to either another secondary DBA or to yourself by
using the appropriate Change Controlling DBA screen. (Although you
will be controlling the data sources after deleting the secondary
DBA, using the Change Controlling DBA screen updates reports and
lists to show the current controller of a data source.)

Impact on PC Users.

Access Server does not allow you to delete a currently active user.

DBA Capabilities.

If you are a secondary DBA, you can only delete the user definitions that
you control.

To Delete a User Definition:.

1. Go to the Delete User screen by typing DU in the Go to screen
field of any menu, or by choosing Delete User f3 at the User
Menu.

2. Type in the user name and press Enter.

The Administrator Utility looks through the data dictionary for
the user name. If it is found, the user definition is deleted.
Also deleted are the user's saved tables.

3. When the screen clears, you can delete another user.

4. To leave this screen, choose Done f8. This returns you to the
User Menu. From there, you can go to another screen or exit the
utility.

Examining User Information

Examine information about users at the Show User (SU) screen and at the
List Users (LU) screen.

These screens provide two different ways to examine the definitions of
users currently defined in the data dictionary:

* Display the definition of a specific user (Show), or

* Display a list of all defined users (List)

Whether you Show or List depends on why you are referencing the
information. The two screens are shown on the next page.

DBA Capabilities.

If you are the primary DBA, you can display both the definition of any
specific user and a list of all defined users.

If you are a secondary DBA, you can display only the definition of a
specific user that you control and a list of only the defined users that
you control.

________________________________________________________________________________________________
| |
| |
| CONFIG List Users Screen: LU |
| Choose Done to return to the User Menu. |
| |
| Page of |
| |
| DBA User Access Group DBA User Access Group |
| |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| |
| Print Previous Next Go To Help Done |
| Page Page Page |
| |
________________________________________________________________________________________________

To Show a Particular User Definition:.

1. Go to the Show User screen by typing SU in the Go to screen field
of any menu, or by choosing Show User f4 at the User Menu.

2. Type in the user name and press Enter.

The current definition of this user appears on the screen.

3. If you want a printout of the user definition, choose the Print
f1 function label.

This sends a copy to the file ADMLIST, which prints to the default
or other specified printer.

4. To see the definition of another user, type in the new user name
over the old one and press Enter.

5. To leave this screen, choose Done f8. This returns you to the
User Menu. From there, you can go to another screen or exit the
utility.

To List All Currently Defined Users:.

1. Go to the List Users screen by typing LU in the Go to screen field
of any menu, or by choosing List Users f5 at the User Menu.

An alphabetically sorted list of the all users defined in the data
dictionary is displayed automatically. Also displayed is the name
of each user's access group and whether or not the user is defined
as a DBA. If you are a secondary DBA, only the users that you
control are listed.

2. If you want a printout of the list, choose the Print f1 function
label.

This sends a copy of the list to the file ADMLIST, which prints to
the default or other specified printer.

3. To leave this screen, choose Done f8. This returns you to the
User Menu. From there, you can go to another screen or exit the
utility.

For more information about a particular user listed, go to the Show User
(SU) screen. (See "To Show...", above.)

MPE/iX 5.0 Documentation