advertisements
_____________________________________________________________________________________________________________________
In many times we wanted to implement the automatic session expiry for the idle session in the databases which are having huge number of user session. Suppose if you wanted to expire the Oracle sessions which are idle more than 3 minutes.
Step 1. Create new profile with IDLE_TIME parameter as 3.
SQL> CREATE PROFILE TEST
LIMIT PASSWORD_REUSE_MAX 10
PASSWORD_REUSE_TIME 30
IDLE_TIME 3 ;
Profile created.
Step 2. Assign the new profile to the users which need to be automatically expired.
SQL> alter user scott profile test;
User altered.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment