Audit Trail

[Rajkartha]

I have a requirement from one of my client to track all the users logged into the oracle instance, what time, terminal number, how long connection used, which all tables modified etc this has to be tracked for DBA users too.

Is there a way we can find all these information from Catalog tables ?

Please help me.


ThanX a lot in advance

Raj

[francisc]

you have to enable audit for database
see Oracle administration guide / Auditing database use

SYS.AUD$ - name of view where audit store information

hope this help.

[julian]

Most of all what his client wants can be achieved only by auditing. Some triggers might have to be made. But they want to audit the DBAs too? DBAs can always disable the triggers or delete from AUD$, etc...