RDBMS maintenance procedure

You can use this procedure to maintain the data in the RDBMS Administration module.

The RDBMS Administration maintenance procedure contains these procedures:

Create or maintain database groups
Create or maintain database users
Create or maintain a link between the LN user and the database user

You can use these procedures as separate and independent procedures. Or as steps in a procedure, which gives individual LN users access to an RDBMS.

This section describes only the most important steps in these procedures.

Note: Some databases cannot handle uppercase characters. Therefore you must create all database user names and group names in lowercase.

This diagram shows the RDBMS Administration maintenance procedure:

To create or maintain database groups

With a database group you can assign a specific set of permissions to multiple users. All members of a database group have the same privileges. A database user must belong to at least one database group. Before you can create a database user, you must create a database group. The reason is that the database user must be assigned to an existing database group. You can use this procedure to create database groups, and to maintain the database group’s data.

Procedure summary

The procedure steps and the corresponding sessions.

Create or maintain database groups
These sessions are used:

Note: Create all database group names in lowercase.

To create or maintain database users

A database user is a user who has access privileges to specific databases that are stored in the database server. The configuration information for the database user contains all required settings to log on to a database. These settings are automatically loaded when the LN user logs on. The group to which the user belongs determines the access privileges of the database user.

Before you can create a database user, you must ensure that a database group exists. The reason for this is because you must assign an existing database group to a database user. To create or maintain database users, and to maintain the database group’s data, you can use this procedure.

Procedure summary

The procedure steps and the corresponding sessions.

Create or maintain database users
These sessions are used:

Note: Create all database user names in lowercase.

To create or maintain a link between an LN user and a database user

An LN user has RDBMS permissions through the link between the LN user and the database user. After you establish the link, the LN user has database permissions for a specific RDBMS.

Before you can use this procedure, you must enure that the LN user and the database user are already defined. If the LN user is not yet created, use the session to create the user. If the database user is not yet created, use the session to create the database user.

Procedure summary

You can use this procedure to give the LN user RDBMS permissions. This procedure links an LN user to a database user. You can also use this procedure to give the LN user permissions for more than one RDBMS.

Create or maintain a link between an LN user and a database user
These sessions are used:

Note: You can link a single LN user to a single database user of the same name. Use the session. For example, you can link many LN users to a single database user. Or link an LN user with a database user of a different name.