| Overview of RDBMS administration |  |
| ERP LN supports several Relational Database Management Systems (RDBMSs) for which you can authorize the ERP LN user. An ERP LN user must be able to use the information that is stored in the RDBMS. Before the ERP LN user can access a database, you must give the ERP 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 ERP 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 ERP LN environment, data is lost in the RDBMS tables. Optimize the table and index repository to optimize the interaction between ERP LN and the database. The following figure shows the link between the ERP LN user and the Database user: ERP LN uses the following entities to make the data in the RDBMS tool manageable: Database group Database user Database groups In ERP 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 ERP LN software. Notes A database base group is password protected. The database group password is a default password and is not visible for the ERP LN user. An ERP LN user has only access to the database via the ERP LN application. It is not allowed for an ERP 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 ERP 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 ERP LN user are role-dependent. As a result, you can restrict the ERP 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 ERP LN ’s Authorization Management System (AMS) to define the database restrictions. It is possible to link a database user to one or more ERP 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 ERP LN user. An ERP LN user has only access to the database via the ERP LN application. It is not allowed for an ERP LN user to logon directly to the database. |