<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/dba_maintenance_procedure" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">RDBMS maintenance procedure</Title>
		<Keyword ContextSensitive="No"><Level1>RDBMS administration</Level1>
			<Level2>maintenance procedure</Level2>
		</Keyword>
	</Header>
	<GeneralSection><SectionTitle>Introduction</SectionTitle>
		<Paragraph class="Default">You can use this procedure to maintain the data in the RDBMS Administration module.</Paragraph>
		<List><ListIntro>The RDBMS Administration maintenance procedure contains the procedures to do the following:</ListIntro>
			<ListItem>Create or maintain database groups</ListItem>
			<ListItem>Create or maintain database users</ListItem>
			<ListItem>Create or maintain a link between the ERP LN user and the database user</ListItem>
		</List>
		<Paragraph class="Default">You can use these procedures as separate and independent procedures, or as steps in a procedure, which gives individual ERP LN users access to an RDBMS.</Paragraph>
		<Paragraph class="Default">This section describes only the most important steps in these procedures.</Paragraph>
		<Figure space-and-orientation="indented-estimated"><FigIntro>The following figure illustrates the RDBMS Administration maintenance procedure:</FigIntro>
			<HTML:IMG height="283" width="254" SRC="../images/tr_graph_dba_maintenance_procedure.gif" path="/enterpriseserver/tools/tt/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="tr_graph_dba_maintenance_procedure.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/images/tr_graph_dba_maintenance_procedure.gif" ID="IDA3AYBC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/></Figure>
	</GeneralSection>
	<GeneralSection><SectionTitle>To create or maintain database groups</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>The following list shows the procedure steps and the corresponding sessions.</ListIntro>
				<ListItem>Create or maintain database groups <List><ListIntro>The following sessions are used:</ListIntro>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0520m000" role="session">Database Groups (ttdba0520m000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0120m000" role="session">Database Groups (ttdba0120m000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0201s000" role="session">Enter Password (ttdba0201s000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0200s000" role="session">Enter Data Base Administrator Password (ttdba0200s000)</Link>
						</ListItem>
					</List>
				</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
	<GeneralSection><SectionTitle>To create or maintain database users</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.</Paragraph>
		<Paragraph class="Default">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:</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>The following list shows the procedure steps and the corresponding sessions.</ListIntro>
				<ListItem>Create or maintain database users <List><ListIntro>The following sessions are used:</ListIntro>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0515m000" role="session">Database Users (ttdba0515m000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0115m000" role="session">Database Users (ttdba0115m000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0201s000" role="session">Enter Password (ttdba0201s000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0200s000" role="session">Enter Data Base Administrator Password (ttdba0200s000)</Link>
						</ListItem>
					</List>
				</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
	<GeneralSection><SectionTitle>To create or maintain a link between an ERP LN user and a database user</SectionTitle>
		<Paragraph class="Default">An ERP LN user has RDBMS permissions through the link between the ERP LN user and the database user. After you establish the link, the ERP LN user will have database permissions for a specific RDBMS.</Paragraph>
		<Paragraph class="Default">Before you can use this procedure, you must make sure that the ERP LN user and the database user are already defined. If the ERP LN user has not yet been created, use the <Link href="/baanerp/tt/aad/ttaad2500m000" role="session">User Data (ttaad2500m000)</Link> session to create the user. If the database user has not yet been created, use the <Link href="/baanerp/tt/dba/ttdba0515m000" role="session">Database Users (ttdba0515m000)</Link> session to create the database user.</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>You can use the following procedure to give the ERP LN user RDBMS permissions. This procedure links an ERP LN user to a database user. You can also use this procedure to give the ERP LN user permissions for more than one RDBMS.</ListIntro>
				<ListItem>Create or maintain a link between an ERP LN user and a database user <List><ListIntro>The following sessions are used:</ListIntro>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0510m000" role="session">Links Between Infor ERP Users and Database Users (ttdba0510m000)</Link>
						</ListItem>
						<ListItem><Link href="/baanerp/tt/dba/ttdba0110m000" role="session">Links between Infor ERP Users and Database Users (ttdba0110m000)</Link>
						</ListItem>
					</List>
				</ListItem>
			</List>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">In addition to enabling you to link a single ERP LN user to a single database user of the same name, the <Link href="/baanerp/tt/dba/ttdba0110m000" role="session">Links between Infor ERP Users and Database Users (ttdba0110m000)</Link> session provides additional flexibility. For example, you can use this session to link many ERP LN users to a single database user, or to link an ERP LN user with a database user of a different name.</Paragraph>
			</Note>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
