RDBMS maintenance procedure

Introduction

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

With the RDBMS Administration maintenance procedure, you can:

  • 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.

Important!

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

The following figure illustrates the RDBMS Administration maintenance procedure:
[...]
To create or maintain database groups

A database group enables you to 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 for this is because the database user must be assigned to an existing database group. You can use the following procedure to create database groups, and to maintain the database group’s data.

Procedure summary

The following list shows the procedure steps and the corresponding sessions.

Important!

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 stored in the database server. The configuration information for the database user contains all necessary 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 make sure 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 the following procedure:

Procedure summary

The following list shows the procedure steps and the corresponding sessions.

Important!

Create all database user names in lowercase.