This discussion is archived
2 Replies Latest reply: Jan 29, 2013 1:35 AM by Osama_Mustafa RSS

Oracle 11g Profile settings not working for user

Arun Natarajan-OC Explorer
Currently Being Moderated
Hi Friends,

I am using Oracle 11g (11.2.0.1)

I created an profile with Idle Time (Minutes)=2 and Connect Time (Minutes)=10an i asssigned it to user1

Then i logged in as user1 and i was idle for more than 5 minutes and then i queried the table and it is working.

But as per the Idle Time = 2 , it should timeout the session if i try to query after 5 minutes

Also i connected as user1 and was idele for more than 15 minutes and then i queried the table and it is working. so as per the Connect Time (Minutes)=10 it has to time out after 10 mins


whereas i tried password lock after 2 failed attemps (through the same profile) and that is working fine.

Why both of the settings not working in 11g?


Regards,
DB

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points