Execute the database structure modification utility (pdmod command), and perform the following. All of the following tasks can be performed simultaneously with a single issuance of the pdmod command.
Register the auditor with the pdmod command's create auditor statement. The auditor can perform the following operations:
Table 22-11 User privileges that can be held by the auditor
Type of user privilege | Yes/No | Remarks |
---|---|---|
Audit privilege | Yes | These privileges are granted automatically when the auditor is registered. |
CONNECT privilege | Yes | |
Schema definition privilege | Yes | |
DBA privilege | No | The auditor cannot hold the DBA privilege. |
RDAREA usage privilege | Yes | The privilege to use the RDAREA that stores the audit trail table must be granted by a user who has the DBA privilege. This also applies to use of other RDAREAs. |
Table access privilege | Yes | The auditor can hold audit trail table access privilege. The privilege to access other tables must be granted by each table's owner. |
Create the RDAREA where the audit trail table will be stored using the pdmod command's create rdarea statement. The following should be considered when creating the RDAREA for storing the audit trail table:
Create the audit trail table with the pdmod command's create audit table statement. The following should be considered when creating the audit trail table: