| # Overview of RDBMS administration LN supports several Relational Database Management Systems (RDBMSs) for which you can authorize the LN user. An LN user must be able to use the information that is stored in the RDBMS. Before the LN user can access a database, 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 and determines the content, internal structure, and access strategy for an RDBMS, defines security and integrity, and monitors performance. You can use the RDBMS Administration module to: 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. The following figure shows the link between the LN user and the Database user: LN uses the following entities to make the data in the RDBMS tool manageable: Database group Database user 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 will be assigned must already exist. A database group is already defined during the installation of the LN software. 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 via 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 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. As a result, 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. It is possible to link a database user to one or more LN users (1 - many relationship). 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 via the LN application. It is not allowed for an LN user to logon directly to the database. |