audit_spec file

The audit_spec file is used to specify audit file parameters. One such file exists for each BSE environment, and is located in the $BSE/lib directory.

The format of the file:

Table Name:Company Number:Audit Specifications

This list provides the meaning of each field:

Table Name

Indicates the table. The table name can have the following formats:

*: All tables in all packages
Package All tables in this package, for example tf, td, and so on
Package and module code All tables in the module, for example, tccom or ttadv
Package, module and table number For example, ttadv999 or tccom010

Company

This can be in one of following formats.

*: All companies
100: Single company, for example, company 100 only
100,000: Comma-separated list of companies, for example, company 100 and 000

Specifications

These specifications can be put in the file:

To sequence:

This sequence is specified by the keyword TOSEQ or toseq, followed by a sequence number. Note that the keyword and the sequence number must be separated by a space, for example:
```
TOSEQ 999 or toseq 999
```
If the end sequence is not specified for a table/company combination, the default is 999.
Maximum sequence file size:

This size is specified by the keyword MAXSEQSIZE or MAXSEQSIZE followed by a size specification. Note that the keyword and the size specification must be separated by a space. The size can be specified in:
- Bytes: For example, MAXSEQSIZE 10000 (10,000 bytes).
- Kilobytes: For example, MAXSEQSIZE 10K (10KB or 10*1024 bytes).
- Megabytes, for example, MAXSEQSIZE 2M (2MB or 2*1024*1024 bytes).

For kilobyte and megabyte specifications, the characters K and M must be uppercase without a space between the number and the specification character.

If the maximum sequence size is not specified for a table or company combination, the default is 512 KB.

Security that is assigned to current table or company number audit files. The security is specified as keyword SECURITY or security followed by a security number. Note that the keyword and the security specifications must be separated by a space, for example:

SECURITY 4 or security 4

This table shows the various security levels and the relevant codes:


Security	Value
Print	4
Clean	8
Maintain	16
Application defined	32

The combination of these security levels is described in Authorizations.

To specify clean and maintain, security is specified as security 24 (the sum of 8 + 16).

You cannot combine an application-defined with print and clean. You can only combine application-defined with maintain permissions. Note that you can place these specifications in any order.

Note: The audit_spec file must have a default entry covering all tables/company numbers. You can specify this with an asterisk (*) for table and company number fields. This must be the last line of the file.

A sample audit_spec file:

ttadv999:000:TOSEQ 99 MAXSEQSIZE 2M
tt:000: toseq 49 maxseqsize 1M
tf:000:toseq 49 maxseqsize 20K
*:*: TOSEQ 499 MAXSEQSIZE 100K

Note: The audit_spec file must have read permission for all users and write permission for the administrator user. Otherwise, users other than the administrator can change the security parameter in the file, which can provide these users with illegal access.