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
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.
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...
Click Here to Expand Forum to Full Width