Home » RDBMS Server » Security » Need to find the no. of users who have not logged into Oracle database since some period of time.
Need to find the no. of users who have not logged into Oracle database since some period of time. [message #204664] Tue, 21 November 2006 10:38 Go to next message
syedashfaq2
Messages: 12
Registered: July 2005
Location: India
Junior Member

Hi Experts,

I am in need of a query or a way to find out the no. of users who have not logged into Oracle database since <say 13 weeks> of time.

Would you please help me?

Many Thanks in Advance,
SA
Re: Need to find the no. of users who have not logged into Oracle database since some period of time [message #204712 is a reply to message #204664] Tue, 21 November 2006 18:11 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Unless you are auditing sessions, this information isn't captured. If you are auditing sessions, then you can look in DBA_AUDIT_TRAIL. Without auditing, you can potentially glean some information for the listener.log file.
Re: Need to find the no. of users who have not logged into Oracle database since some period of time [message #205365 is a reply to message #204712] Fri, 24 November 2006 06:14 Go to previous messageGo to next message
syedashfaq2
Messages: 12
Registered: July 2005
Location: India
Junior Member

Thnks for this info ebrian!!!
Re: Need to find the no. of users who have not logged into Oracle database since some period of time [message #206511 is a reply to message #204664] Thu, 30 November 2006 06:46 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
you can also write a "on logon"-database trigger.

For the moment I'm monitoring a user in a certain database. Just to see how many times he is using it. And for this I'm also using a on loggon trigger.


For your problem, there are serveral good solutions.

Kr
Karel.
Previous Topic: alter user admin option
Next Topic: special characters in username
Goto Forum:
  


Current Time: Fri Dec 09 05:45:49 CST 2016

Total time taken to generate the page: 0.11582 seconds