Home » SQL & PL/SQL » SQL & PL/SQL » How many times a user has been logged in on a particular day? (oracle9i)
How many times a user has been logged in on a particular day? [message #340767] Thu, 14 August 2008 03:52 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
From which table I can know user info like how many times a user has been logged in on a particular day? v$session?

Thanks in advance,


Regards,
Oli
______________________________________________
Knowledge grows through sharing, share it..

[Updated on: Thu, 14 August 2008 03:58]

Report message to a moderator

Re: How many times a user has been logged in on a particular day? [message #340768 is a reply to message #340767] Thu, 14 August 2008 03:57 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
I don't think it's provided by oracle.

you have to write some code for it.

from V$session you can get time for the sessions when those started.

Regards,
Rajat
Re: How many times a user has been logged in on a particular day? [message #340769 is a reply to message #340768] Thu, 14 August 2008 04:00 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Read this:-

http://www.dba-oracle.com/art_builder_sec_audit.htm
Re: How many times a user has been logged in on a particular day? [message #340773 is a reply to message #340769] Thu, 14 August 2008 04:17 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
rajatratewal wrote on Thu, 14 August 2008 04:00
Read this:-

http://www.dba-oracle.com/art_builder_sec_audit.htm



Good one! Thanks

Regards,

Oli
Re: How many times a user has been logged in on a particular day? [message #340774 is a reply to message #340767] Thu, 14 August 2008 04:30 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
It might be that you are just being curious on how to do it, but what would be the business need to know this?
Why does anyone care whether I connect once or twice? Maybe I pressed a wrong button and got disconnected. What do these figures tell you?
Re: How many times a user has been logged in on a particular day? [message #340775 is a reply to message #340767] Thu, 14 August 2008 04:41 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"audit session" then query dba_audit_trail.

Regards
Michel
Previous Topic: One Time Only Procedure
Next Topic: Select The Max year and their Month
Goto Forum:
  


Current Time: Sun Feb 09 07:36:53 CST 2025