Dba audit trail

Hi,

I have a requirement to generate an audit report based on Employee and Department like the below

1) Can select employee Id(emp table) or manager name(manager table)
2) Department(dept table)

Report should have the following when they access the tables.generate the audit information

TO_CHAR(EXTENDED_TIMESTAMP,'YYYY-MM-DD HH:MI:SS'),
OS_USER,
DB_USER,
OBJECT_NAME,
STATEMENT_TYPE,
TERMINAL, (dba_trail_table)
manager name (manger table)
employee Id (emp table)

like which manager tried to access which employee
can you please advise.
Sarma VadlamaniprogrammeranalystAsked:
Who is Participating?
 
sdstuberCommented:
dba_audit_trail doesn't give you that kind of resolution.

you'll need to use fine-grained auditing options to do that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.