Check out the AUDIT command.
a) set audit_trail = db in init.ora
b SQL audit session
and then use the DBA_AUD... views
(and truncate SYS.AUD$ from time to time)
hth
connor
--- [EMAIL PROTECTED] wrote:
Hi, everyone,
I am trying to create usage report for one of our
applications. I
Hi, everyone,
I am trying to create usage report for one of our applications. I don't know if
there is any existing Oracle objects that I can use to retrieve information like
Username, login time, logout time and the history.
If you know some object like this, please email me back. Thanks!