RDBMS maintenance procedure

Introduction

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

The RDBMS Administration maintenance procedure contains the procedures to do the following:

  • Create or maintain database groups
  • Create or maintain database users
  • Create or maintain a link between the Infor 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 Infor 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 Infor 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.

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

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

Before you can use this procedure, you must make sure that the Infor LN user and the database user are already defined. If the Infor LN user has not yet been created, use the Données utilisateur (ttaad2500m000) session to create the user. If the database user has not yet been created, use the Utilisateurs base de données (ttdba0515m000) session to create the database user.

Procedure summary

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

Remarque

In addition to enabling you to link a single Infor LN user to a single database user of the same name, the Liens entre utilisateurs ERP et ceux de la base de données (ttdba0110m000) session provides additional flexibility. For example, you can use this session to link many Infor LN users to a single database user, or to link an Infor LN user with a database user of a different name.