Overview of RDBMS administration

Several Relational Database Management Systems (RDBMSs) are supported by LN for which you can authorize the LN user.

Before the LN user can access a database and can use the information that is stored in the RDBMS. You must give the LN user permission to access the RDBMS.

An RDBMS is a relational database or database management system that consists of tables made up of rows and columns. In a relational database, the rows of a table represent records and the columns represent fields with the particular attributes of a record. The records are collections of information about separate items. The attributes of the records are represented in the columns.

A database administrator (DBA) or system administrator manages an RDBMS. Tasks of a DBA are to determine the content, internal structure, and access strategy for an RDBMS. Defining security and integrity, and monitoring performance.

You can use the RDBMS Administration module for these tasks:

  • Give LN users access to an RDBMS.
  • Transfer the database user file and database group file to the RDBMS Administration module. You can use these tools if, during a migration to an updated LN environment, data is lost in the RDBMS tables.
  • Optimize the table and index repository to optimize the interaction between LN and the database.

This diagram shows the link between the LN user and the Database user:

To make the data in the RDBMS tool manageable, these entities are used in LN:

Database groups

In LN, a database user must belong to a database group. A database group enables the DBA to assign a specific set of privileges to multiple users. All members of a group have the same privileges. Before you create a database user, the database group to which the user must be assigned must already exist.

A database group is already defined during the installation of the LN software.

Database group notes

A database base group is password protected.

The database group password is a default password and is not visible for the LN user.

An LN user has only access to the database through the LN application.

It is not allowed for an LN user to logon directly to the database.

Database user

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 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 add a database user, you must create a database group to which you can assign the user.

The table authorizations of an LN user are role-dependent. Therefore, you can restrict the LN user to those tables or table fields in the RDBMS that are applicable for the employee’s role in an organization. You can use LN ’s Authorization Management System (AMS) to define the database restrictions.

You can link a database user to one or more LN users (1 - many relationship).

Database user notes

A database user is password protected.

The database user password is a default password and is not visible for the LN user.

An LN user has only access to the database through the LN application.

It is not allowed for an LN user to logon directly to the database.