Oracle Audit

最近有人在问要怎么查询audit的数据,在网上找了点资料,还是纪录下来的好..

View Audit Trail
The audit trail is stored in the SYS.AUD$ table. It's contents can be viewed directly or via the following views:

DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS

The audit trail contains alot of data, but the following are most likely to be of interest:

Username : oracle Username.
Terminal : Machine that the user performed the action from.
Timestamp : When the action occured.
Object Owner : The owner of the object that was interacted with.
Object Name : The name of the object that was interacted with.
Action Name : The action that occured against the object. (Insert, Update, Delete, Select, EXECUTE)

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>