SYSCAT.AUDITEXCEPTIONS catalog view
Each row represents an audit exception that is associated with an object.
| Column Name | Data Type | Nullable | Updatable | Description |
|---|---|---|---|---|
| CREATE_TIME | TIMESTAMP | Time at which the audit exception was created. | ||
| OBJECTSCHEMA | VARCHAR (128) | Y | Schema name of the object for which subjects have auditing exceptions. OBJECTSCHEMA is null if OBJECTTYPE identifies an object to which a schema does not apply. | |
| OBJECTNAME | VARCHAR (128) | Unqualified name of the object for which subjects have auditing exceptions. | ||
| OBJECTTYPE | CHAR(1) | The type of object for which subjects have auditing exceptions. Blank=Database. | ||
| EXOBJECTSCHEMA | VARCHAR (128) | Y | Schema name of the subject that is excepted from auditing of the object. SUBJECTSCHEMA is null if EXOBJECTTYPE identifies an object to which a schema does not apply. | |
| EXOBJECTNAME | VARCHAR (128) | Unqualified name of the subject that is excepted from auditing of the object. | ||
| EXOBJECTTYPE | CHAR(1) | The type of subject that is excepted from auditing of the object. x = Trusted contexts |