-
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
-
audit
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.
-
Re: audit
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|