IT Release Management

Appendix I: Operational Readiness Testing Manual (ORT) ◾ 245

Database Tasks Status

Ensure system triggers fire.

Objects in application tablespaces not owned by the schema owner

should be dropped.

Audit quota use per user.

Establish different users for schema management and data

management.

Set up naming conventions for schema owners and administrators

and users.

Audit users’ database triggers.

Auditing

Configure audit and storage.

Audit insert failures on critical objects.

Use triggers to capture login events.

Audit create session.

Audit use of all grant privileges.

Audit the use of all drop statements.

Audit the use of all alter statements.

Audit the use of ...