<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/aud_general_remarks" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Audit - General remarks</Title>
		<Keyword ContextSensitive="No"><Level1>Audit configuration management</Level1>
			<Level2>general remarks</Level2>
		</Keyword>
	</Header>
	<AimSection><Paragraph class="Default">The commands that cause a table transaction to be audited, are only the commands that affect the table data, that is, Insert, Update, and Delete commands. Several table level commands that affect all rows in a table are also audited, such as Create Table, Drop Table, and Clear Table.</Paragraph>
		<Paragraph class="Default">The audit configuration uses a positive approach, which means that you can only define the tables and fields that must be audited, but not the tables and fields that must not be audited. To compensate for this feature, you can load lists of all packages, modules, tables or fields through the <GUIRef href="" role="manual">Specific</GUIRef> menu of the sessions concerned.</Paragraph>
		<List><ListIntro>Because you can use tables and fields in various profiles with conflicting settings, the following rules determine which setting take precedence over the conflicting setting:</ListIntro>
			<ListItem>A higher level takes precedence over a lower level. Therefore, if you define in profile A that all tables in a module must be audited, but in profile B that only one table in this module must be audited, the result, if you convert these profiles to run time, is that all modules in the package concerned are audited.</ListItem>
			<ListItem>The setting <GUIRef href="" role="manual">Always</GUIRef> takes precedence over <GUIRef href="" role="manual">Changed</GUIRef>. Therefore, if profile A defines that a field must only be audited, when the profile is changed, and profile B defines that this field must always be audited, the field is always audited.</ListItem>
		</List>
		<Paragraph class="Default">The following tables illustrate this behavior.</Paragraph>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH colspan="4" rowspan="1">Result of conflicting audit type settings</TH>
				</TR>
				<TR><TH rowspan="1" colspan="1">Package</TH>
					<TH rowspan="1" colspan="1">Module</TH>
					<TH rowspan="1" colspan="1">Table</TH>
					<TH rowspan="1" colspan="1">Audit Type</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">200</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TH colspan="4" rowspan="1">Result</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
			</TBODY>
		</TABLE>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH colspan="4" rowspan="1">Result of conflicting audit type settings</TH>
				</TR>
				<TR><TH rowspan="1" colspan="1">Package</TH>
					<TH rowspan="1" colspan="1">Module</TH>
					<TH rowspan="1" colspan="1">Table</TH>
					<TH rowspan="1" colspan="1">Audit Type</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">200</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
				<TR><TH colspan="4" rowspan="1">Result</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">200</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
			</TBODY>
		</TABLE>
		<Paragraph class="Default">If company groups are also added to a profile, the result of the convert to run time action on these profiles is determined by these company groups also, as illustrated in the following table.</Paragraph>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH colspan="5" rowspan="1">Result of conflicting audit type settings</TH>
				</TR>
				<TR><TH rowspan="1" colspan="1">Package</TH>
					<TH rowspan="1" colspan="1">Module</TH>
					<TH rowspan="1" colspan="1">Table</TH>
					<TH rowspan="1" colspan="1">Company</TH>
					<TH rowspan="1" colspan="1">Audit Type</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">001, 002</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">002, 003</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">200</TD>
					<TD rowspan="1" colspan="1">002, 004</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TH colspan="5" rowspan="1">Result</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">001, 002</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">*</TD>
					<TD rowspan="1" colspan="1">002, 003</TD>
					<TD rowspan="1" colspan="1">Always</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">tt</TD>
					<TD rowspan="1" colspan="1">adv</TD>
					<TD rowspan="1" colspan="1">200</TD>
					<TD rowspan="1" colspan="1">004</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
				</TR>
			</TBODY>
		</TABLE>
		<Paragraph class="Default">The following table displays the same information, but now by company, and only for table ttadv200.</Paragraph>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH colspan="3" width="512" rowspan="1">Possible combinations of audit type and field specification</TH>
				</TR>
				<TR><TH rowspan="1" colspan="1">Companies</TH>
					<TH rowspan="1" colspan="1">Audit Type</TH>
					<TH width="310" rowspan="1" colspan="1">Comment</TH>
				</TR>
				<TR><TD rowspan="1" colspan="1">001</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
					<TD width="310" rowspan="1" colspan="1">2</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">002, 003</TD>
					<TD rowspan="1" colspan="1">Always</TD>
					<TD width="310" rowspan="1" colspan="1">4</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">004</TD>
					<TD rowspan="1" colspan="1">Changed</TD>
					<TD width="310" rowspan="1" colspan="1"></TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">005</TD>
					<TD rowspan="1" colspan="1">-</TD>
					<TD width="310" rowspan="1" colspan="1">For other companies, table ttadv200 is not audited.</TD>
				</TR>
			</TBODY>
		</TABLE>
		<Paragraph class="Default">You can configure audit settings for tables in another package combination. However, you cannot zoom to these tables. You must enter these tables manually.</Paragraph>
		<List><ListIntro>If you convert the audit configuration to run time, the result is stored in the following four files, which you can find in the <Code>$BSE\lib</Code> directory:</ListIntro>
			<ListItem><Code>audit_spec</Code>
			</ListItem>
			<ListItem><Code>audit_cols</Code>
			</ListItem>
			<ListItem><Code>audit_hosts</Code>
			</ListItem>
			<ListItem><Code>auditdef6.2</Code>
			</ListItem>
		</List>
	</AimSection>
</ManualTopic>
