<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/ams/ttams3145m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Data Authorizations (ttams3145m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><List><ListIntro> 
                                    Use this session to maintain table data authorizations. This means that you can specify restrictions for normal users that are linked to the role to do database actions on records of a table for a given condition. Table data authorizations are specified for a range of data in a table by defining a condition. The authorization that is defined in this session can be an exception or addition to the authorizations that are defined in:</ListIntro>
				<ListItem>The <GUIRef href="/baanerp/tt/ams/ttams3144m000" role="session">Table Authorizations by Company (ttams3144m000)</GUIRef> session</ListItem>
				<ListItem>The <GUIRef href="/baanerp/tt/ams/ttams3140m000" role="session">Table Authorizations by Package (ttams3140m000)</GUIRef> session</ListItem>
				<ListItem>The <GUIRef href="/baanerp/tt/ams/ttams3141m000" role="session">Table Authorizations by Module (ttams3141m000)</GUIRef> session</ListItem>
				<ListItem>The <GUIRef href="/baanerp/tt/ams/ttams3142m000" role="session">Table Authorizations by Table (ttams3142m000)</GUIRef> session</ListItem>
			</List>
		</AimSection>
		<GeneralSection><Paragraph class="Default">You can use table data authorizations to block specific data in the database for normal users that are linked to the role.</Paragraph>
			<Paragraph class="Default">You can define authorizations depending on the data of a table. For example, a user can only be allowed to insert sales orders with the order number is between 100.000 and 200.000.</Paragraph>
			<Paragraph class="Default">You can specify an authorization level, for each condition, for example, the data authorization. This can be another authorization level as the table authorization level, which is defined in the <Link href="/baanerp/tt/glossary/glossary#100002" role="glossary">database table authorization</Link> sessions. If you have not specified table authorizations, the table authorization status is delete, insert, modify, or read.</Paragraph>
			<Paragraph class="Default">An overlap can occur between two conditions for the same table with different authorization levels. The most restrictive authorization level is taken in this case.</Paragraph>
			<Paragraph class="Default">For the meaning of the condition within the expression, see the list of expressions below:</Paragraph>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH rowspan="1" colspan="1">Cond.</TH>
						<TH rowspan="1" colspan="1">Seq.</TH>
						<TH rowspan="1" colspan="1">Field</TH>
						<TH rowspan="1" colspan="1">Operator</TH>
						<TH rowspan="1" colspan="1">Value 1</TH>
						<TH rowspan="1" colspan="1">And/Or/End</TH>
					</TR>
					<TR><TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">X</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">And</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">2</TD>
						<TD rowspan="1" colspan="1">Y</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">3</TD>
						<TD rowspan="1" colspan="1">Or</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">2</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">Z</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">4</TD>
						<TD rowspan="1" colspan="1">End</TD>
					</TR>
				</TBODY>
			</TABLE>
			<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH rowspan="1" colspan="1">Cond.</TH>
						<TH rowspan="1" colspan="1">Seq.</TH>
						<TH rowspan="1" colspan="1">Field</TH>
						<TH rowspan="1" colspan="1">Operator</TH>
						<TH rowspan="1" colspan="1">Value 1</TH>
						<TH rowspan="1" colspan="1">And/Or/End</TH>
					</TR>
					<TR><TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">X</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">And</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">2</TD>
						<TD rowspan="1" colspan="1">1</TD>
						<TD rowspan="1" colspan="1">Y</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">3</TD>
						<TD rowspan="1" colspan="1">Or</TD>
					</TR>
					<TR><TD rowspan="1" colspan="1">2</TD>
						<TD rowspan="1" colspan="1">2</TD>
						<TD rowspan="1" colspan="1">Z</TD>
						<TD rowspan="1" colspan="1">equal</TD>
						<TD rowspan="1" colspan="1">4</TD>
						<TD rowspan="1" colspan="1">End</TD>
					</TR>
				</TBODY>
			</TABLE>
		</GeneralSection>
		<GeneralSection><Paragraph class="Default">When specifying the two expressions, they will turn out to be different.</Paragraph>
			<Paragraph class="Default">Expression 1: (X=1 and Y=3) or (Z=4) Expression 2: (X=1) and (Y=3 or Z=4)</Paragraph>
			<Paragraph class="Default">You can define the table data authorizations for all companies or for a specific company. The authorizations for the specific company have the highest authority in this case.</Paragraph>
			<Paragraph class="Default">The table data authorizations are an exception to the database table authorizations at <Link href="/baanerp/tt/glossary/glossary#000023" role="glossary">company</Link> level, at <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> level, at module level, and at table level.</Paragraph>
			<List><ListIntro>You can use the <GUIRef href="" role="menu">Specific</GUIRef> menu to:</ListIntro>
				<ListItem>Delete the table data authorizations for a range of tables.</ListItem>
				<ListItem>Convert the changes of the database table authorizations to the run-time data dictionary. The database authorization data of the role is stored in the $BSE/lib/db/&lt;first character of role&gt;/&lt;role&gt;.</ListItem>
				<ListItem>Copy the database table authorization to the related child fields when a field refers to the related table and the field is part of the primary key of the table for which the database table authorizations is defined.</ListItem>
			</List>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000001" role="manual">To use an overview session</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/basictasks/000035" role="manual">To maintain records in an overview session</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttams345.crol"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Role</Title>
			</Header>
			<FuncDesc>Specifies the code of the <Link href="/baanerp/tt/glossary/glossary#000017" role="glossary">role</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams200.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Role</Title>
			</Header>
			<FuncDesc>The description of the <Link href="/baanerp/tt/glossary/glossary#000017" role="glossary">role</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.allc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">All Companies</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the authorizations are defined for all companies.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If authorizations are defined for a specific company as well as for all companies, they can overlap. The authorizations for a specific company have the highest priority.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttams345.comp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>Specifies the code of the <Link href="/baanerp/tt/glossary/glossary#000023" role="glossary">company</Link> for which the <Link href="/baanerp/tt/glossary/glossary#100002" role="glossary">database table authorizations</Link> at table data-level are defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad100.cpnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>The description of the <Link href="/baanerp/tt/glossary/glossary#000023" role="glossary">company</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.tabl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>Specifies the code of the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link> for which the <Link href="/baanerp/tt/glossary/glossary#100002" role="glossary">database table authorizations</Link> at table-data level are defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="table.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The description of the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.perm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Authorization</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#100002" role="glossary">database table authorizations</Link> type, which is defined for the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">tables</Link>. This information is used by the server to determine whether a user is authorized to carry out a database action on the tables in the package, depending on the specified <Link href="/baanerp/tt/glossary/glossary#100006" role="glossary">expression</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.autn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Cond.</Title>
			</Header>
			<FuncDesc>If the expression consists of multiple conditions, the condition sequence-number is specified.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The use of a condition sequence number in relation to the serial number can be explained with the following examples:</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH rowspan="1" colspan="1">Cond.</TH>
							<TH rowspan="1" colspan="1">Sern</TH>
							<TH rowspan="1" colspan="1">Field</TH>
							<TH rowspan="1" colspan="1">Operand</TH>
							<TH rowspan="1" colspan="1">Value 1</TH>
							<TH rowspan="1" colspan="1">And/Or/End</TH>
						</TR>
						<TR><TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">X</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">And</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">Y</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">3</TD>
							<TD rowspan="1" colspan="1">Or</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">Z</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">4</TD>
							<TD rowspan="1" colspan="1">End</TD>
						</TR>
					</TBODY>
				</TABLE>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH rowspan="1" colspan="1">Cond.</TH>
							<TH rowspan="1" colspan="1">Sern</TH>
							<TH rowspan="1" colspan="1">Field</TH>
							<TH rowspan="1" colspan="1">Operand</TH>
							<TH rowspan="1" colspan="1">Value 1</TH>
							<TH rowspan="1" colspan="1">And/Or/End</TH>
						</TR>
						<TR><TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">X</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">And</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">Y</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">3</TD>
							<TD rowspan="1" colspan="1">Or</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">Z</TD>
							<TD rowspan="1" colspan="1">equal</TD>
							<TD rowspan="1" colspan="1">4</TD>
							<TD rowspan="1" colspan="1">End</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph class="Default">Expression 1: (X=1 and Y=3) or (Z=4) Expression 2: (X=1) and (Y=3 or Z=4)</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttams345.sern"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Sern</Title>
			</Header>
			<FuncDesc>Specifies the number of the subexpression in the condition. An <Link href="/baanerp/tt/glossary/glossary#100006" role="glossary">expression</Link> can contain more than one subexpression.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.fdnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field</Title>
			</Header>
			<FuncDesc>Specifies the code of the table field to which the condition applies.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.oper"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Operator</Title>
			</Header>
			<FuncDesc>Specifies the operator that you can use in the expression.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.val1"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Value 1</Title>
			</Header>
			<FuncDesc>The value of the field in the condition.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.val2"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Value 2</Title>
			</Header>
			<FuncDesc>Only if the operator is between or not between, the second value applicable.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttams345.andor"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">And/Or/End</Title>
			</Header>
			<FuncDesc>The operator who links two conditions, which can be and or which can be or. The expression is closed by using end of expression. If you have entered a condition that is closed by end of expression, all conditions after that will be ignored.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
