Home » RDBMS Server » Security » unable to use connect-time and idle_time
unable to use connect-time and idle_time [message #151076] Tue, 13 December 2005 00:45 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

I have set the resource_limit=true. created a profile with the following:

session_per_user=2
connect_time=5
idle_time=1

I assigned this profile to a user. Now when i connect as this user, it does not allow me more than 2 sessions. But, i am able to work on my session without any restriction imposed by connect_time and idle_time..Please justify


Regards,
reena






Re: unable to use connect-time and idle_time [message #151475 is a reply to message #151076] Thu, 15 December 2005 00:29 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Good revision stuff.

Even i was able to replicate your problem upto some extent.

I set the same values for scott's profile.

SQL> select * from dba_profiles
  2  where profile='CHECK_PROF'
  3  and resource_name in ('IDLE_TIME','CONNECT_TIME');

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
CHECK_PROF                     IDLE_TIME                        KERNEL
1

CHECK_PROF                     CONNECT_TIME                     KERNEL
2

11:45:05 SQL> select username,profile from dba_users
11:45:12   2  where username='SCOTT';    

USERNAME                       PROFILE
------------------------------ ------------------------------
SCOTT                          CHECK_PROF


11:51:32 SQL> conn scott/tiger
Connected.

11:53:44 SQL> create table t2(n1 number);
create table t2(n1 number)
*
ERROR at line 1:
ORA-02396: exceeded maximum idle time, please connect again

11:57:19 SQL> conn scott/tiger     
Connected.

12:02:27 SQL> create table n1(col1 number);

Table created.

12:03:02 SQL> drop table n1;

Table dropped.

12:05:09 SQL>


As i can interpret , if the session is remained idle for more than 2-3 minutes then it gets disconnected otherwise it remains connected.

Need more inputs from others.

Regards,
tarun
Previous Topic: History of Passwords..
Next Topic: remote db connectvity
Goto Forum:
  


Current Time: Thu Dec 02 09:29:54 CST 2021