Home » RDBMS Server » Security » I want to get the user login/logout information for past 30 days (Windows )
I want to get the user login/logout information for past 30 days [message #541897] Fri, 03 February 2012 01:42 Go to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
Hi everybody, I just want to know the user login/logout information for the past 31days. how can i get that?? can you please guide me with the respective steps??.. and
Can i get it through OEM?


thanks in advance.
Re: I want to get the user login/logout information for past 30 days [message #541898 is a reply to message #541897] Fri, 03 February 2012 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't unless you activated audit on the session.
If all connections are made remotely, you can have a look at listener.log to get the connection requests, not more.

Regards
Michel
Re: I want to get the user login/logout information for past 30 days [message #541899 is a reply to message #541898] Fri, 03 February 2012 01:45 Go to previous messageGo to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
where can i find that listener.log? and i have enable auditing yesterday only.



actually the thing is....My company uses oracle as the back-end database for arc catalog (GIS) so all the users connect(to server) from their arc catalog tool installed in their computers. Now i need to know the user log information like when did the user logged in and when did they logged off!!!
Pleasegive me a detailed or step by step explanation so that it will be helpfull to me..
THanks in advance Michel Cadot

[Updated on: Fri, 03 February 2012 02:03]

Report message to a moderator

Re: I want to get the user login/logout information for past 30 days [message #541903 is a reply to message #541899] Fri, 03 February 2012 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Now i need to know the user log information like when did the user logged in and when did they logged off!!!


So it is application login information you want then ask the application to give it not Oracle.

Regards
Michel
Re: I want to get the user login/logout information for past 30 days [message #541908 is a reply to message #541903] Fri, 03 February 2012 02:36 Go to previous messageGo to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
But i have created the users in oracle as it is the database .. and they select the required tables(map) from the database ..
But nowhere i found the users log info in the application so i came to database.!!
Re: I want to get the user login/logout information for past 30 days [message #541909 is a reply to message #541908] Fri, 03 February 2012 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But nowhere i found the users log info in the application so i came to database.!!


And you found nothing in the database as you didn't activate the proper feature.
If you want application login information, ask the application to log them, now.
Database login audit is for database login information.
Two different things.

Regards
Michel
Re: I want to get the user login/logout information for past 30 days [message #541910 is a reply to message #541909] Fri, 03 February 2012 02:46 Go to previous messageGo to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
ok....In my view I thought that the login information of the application will also reside in the history of the oracle database as it is the back end!
Re: I want to get the user login/logout information for past 30 days [message #541913 is a reply to message #541910] Fri, 03 February 2012 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it resides inside the database only if the application explicitly records it.
How could Oracle know what is done in the front end? Only if the application tells it.

Many applications can do things without connecting to a database and do other things connecting to the database.
Many applications can do things on several databases (Oracle and/or not Oracle) for the same application connection.
These show that an application connection and a database connection are different.

Regards
Michel
Re: I want to get the user login/logout information for past 30 days [message #541918 is a reply to message #541913] Fri, 03 February 2012 03:07 Go to previous messageGo to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
ok Thank You for Your Valuable info Michel !! Will be back with some more doubts(things to learn) Razz

Thank you
Re: I want to get the user login/logout information for past 30 days [message #541923 is a reply to message #541918] Fri, 03 February 2012 03:23 Go to previous messageGo to next message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
But Michel what happens is the user logon information(username/password) is stored in the database ..and so when the user gives the username and password it goes and check in the database and if it is correct then it will connect to the server(or application residing in the server) right?. so is there a chance of getting ? I am just clearing my doubts Michel
Re: I want to get the user login/logout information for past 30 days [message #541925 is a reply to message #541923] Fri, 03 February 2012 03:24 Go to previous messageGo to next message
cookiemonster
Messages: 11076
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the application stores application login/logout details in the DB then of course you can get it, it's just data in a table.
Re: I want to get the user login/logout information for past 30 days [message #541929 is a reply to message #541925] Fri, 03 February 2012 03:37 Go to previous message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
OK Cookie monster thank you!
Previous Topic: obssocookie is getting set as TEST
Next Topic: Oracle Login Fail
Goto Forum:
  


Current Time: Sat Oct 25 02:54:47 CDT 2014

Total time taken to generate the page: 0.10892 seconds