-
Hello
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.
Amol
-
You have to enable auditing to do this.
Regards
Gert
-
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..
Radhakrishnan.M
-
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.
- Rajeev
-
Hi
Can you tell me how to enable auditing option
and also i am using Oracle 8i
Amol
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
|