I would like to know whether I can see history of users logged in in oracle for a past few days. Currently our oracle has installed at remote server and I am accessing it using database links from my local oracle. If I want to who has logged on 2 days back and for what time how can I know it. Which system table contains this information.
You have to enable auditing to do this.
If you are using 8i inform .
database event triggers can be used for the same.
It is quite easy and maintence free...
pls inform if you have any troubles..
If you haven't implemented any of the procedures mentioned above then you may want to look into the Listener log file that keeps information of all the connections.
This file could be found in oracle_home\network\log on the database server.
Can you tell me how to enable auditing option
and also i am using Oracle 8i
Click Here to Expand Forum to Full Width