<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/dba_overview" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Overview of RDBMS administration</Title>
		<Keyword ContextSensitive="No"><Level1>User management</Level1>
			<Level2>overview</Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">
                              ERP LN supports several <Link href="/baanerp/tt/glossary/glossary#000000000000024" role="glossary">Relational Database Management Systems</Link> (RDBMSs) for which you can authorize the <Link href="/baanerp/tt/glossary/glossary#000000000000023" role="glossary"> ERP LN user</Link>. 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.</Paragraph>
		<Paragraph class="Default">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.</Paragraph>
		<Paragraph class="Default">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.</Paragraph>
		<List><ListIntro>You can use the RDBMS Administration module to:</ListIntro>
			<ListItem>Give ERP LN users access to an RDBMS.</ListItem>
			<ListItem>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.</ListItem>
			<ListItem>Optimize the table and index repository to optimize the interaction between ERP LN and the database.</ListItem>
		</List>
		<Figure space-and-orientation="indented-estimated"><FigIntro>The following figure shows the link between the ERP LN user and the <Link href="/baanerp/tt/glossary/glossary#000000000000022" role="glossary">Database user</Link>:</FigIntro>
			<HTML:IMG height="247" width="408" SRC="../images/tr_graph_dba_link_user_to_db_user.gif" path="/enterpriseserver/tools/tt/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="tr_graph_dba_link_user_to_db_user.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/images/tr_graph_dba_link_user_to_db_user.gif" ID="IDAUAYBC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/></Figure>
		<List><ListIntro>
                                 ERP LN uses the following entities to make the data in the RDBMS tool manageable:</ListIntro>
			<ListItem><Link href="/baanerp/tt/glossary/glossary#000000000000021" role="glossary">Database group</Link>
			</ListItem>
			<ListItem>Database user</ListItem>
		</List>
	</GeneralSection>
	<GeneralSection><SectionTitle>Database groups</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
		<Paragraph class="Default">A database group is already defined during the installation of the ERP LN software.</Paragraph>
		<Note><SectionTitle>Notes</SectionTitle>
			<Paragraph class="Default">A database base group is password protected.</Paragraph>
			<Paragraph class="Default">The database group password is a default password and is not visible for the ERP LN user.</Paragraph>
			<Paragraph class="Default">An ERP LN user has only access to the database via the ERP LN application.</Paragraph>
			<Paragraph class="Default">It is not allowed for an ERP LN user to logon directly to the database.</Paragraph>
		</Note>
	</GeneralSection>
	<GeneralSection><SectionTitle>Database user</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
		<Paragraph class="Default">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.</Paragraph>
		<Paragraph class="Default">It is possible to link a database user to one or more ERP LN users (1 - many relationship).</Paragraph>
		<Note><SectionTitle>Notes</SectionTitle>
			<Paragraph class="Default">A database user is password protected.</Paragraph>
			<Paragraph class="Default">The database user password is a default password and is not visible for the ERP LN user.</Paragraph>
			<Paragraph class="Default">An ERP LN user has only access to the database via the ERP LN application.</Paragraph>
			<Paragraph class="Default">It is not allowed for an ERP LN user to logon directly to the database.</Paragraph>
		</Note>
	</GeneralSection>
</ManualTopic>
