OraFAQ Forum: Security » Need to find the no. of users who have not logged into Oracle database since some period of time.

Home » RDBMS Server » Security » Need to find the no. of users who have not logged into Oracle database since some period of time.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

syedashfaq2
Messages: 12
Registered: July 2005
Location: India

Junior Member

Thnks for this info ebrian!!!

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	alter user admin option
Next Topic:	special characters in username

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 24 11:34:09 CDT 2022