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

Achtung!

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.

Achtung!

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.

Achtung!

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 will have database permissions for a specific RDBMS.

Before you can use this procedure, you must make sure that the LN user and the database user are already defined. If the LN user has not yet been created, use the User Data (ttaad2500m000) session to create the user. If the database user has not yet been created, use the Database Users (ttdba0515m000) session to create the database user.

Procedure summary

You can use the following 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.

Hinweis

In addition to enabling you to link a single LN user to a single database user of the same name, the Links between Infor ERP Users and Database Users (ttdba0110m000) session provides additional flexibility. For example, you can use this session to link many LN users to a single database user, or to link an LN user with a database user of a different name.