Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

user details in oracle

Status
Not open for further replies.

amolso

Programmer
Sep 8, 2000
71
0
0
IN
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 New to dba world, so please ......
 
no time, so quickly

The data dictionary of oracle store informatíon since the
last startup of the instance, if your DB is shutingdown and
startingup all days, perhaps you need to use AUDIT
(prevoiusly you must run cataudit.sql,...)

You also can use sqlnet-log, or even Operating system logs,
I need more information about your instalation and
your privileges....

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top