2 Replies Latest reply: Jan 29, 2013 3:35 AM by Osama_Mustafa RSS

    Oracle 11g Profile settings not working for user

    Arun Natarajan-OC
      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