This section explains the operands of the create audit table statement. In the following table, the number corresponds to the explanation of the operand.
No. | Operand |
---|---|
1 | create audit table [table-identifier] |
2 | in RDAREA-name |
-- | ; |
~<identifier> ((1-30)) <<SQL_AUDIT_TRAIL>>
Specifies a table identifier for the audit trail table. If this information is omitted, SQL_AUDIT_TRAIL is assumed.
To treat the table identifier as being case sensitive, enclose the entire identifier in double quotation marks ("). If the identifier is not enclosed in double quotation marks, it is treated as being all uppercase letters.
You cannot specify in as the table identifier.
~<identifier> ((1-30))
Specifies the name of the RDAREA (user RDAREA) that is to store the audit trail table. This RDAREA must be accessible only by the auditor. An error results if the specified RDAREA can be accessed by a user who is not the auditor.
To treat the RDAREA name as being case sensitive, enclose the entire name in double quotation marks ("). If the name is not enclosed in double quotation marks, it is treated as being all uppercase letters.