Re: time out

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 13 Feb 2003 08:41:53 -0800
Message-ID: <3E4BCAD1.5E69A7D9@exesolutions.com>

Eric DN wrote:

> Hello,
>
> 2 questions only:
>
> -Where is the parameter in Oracle 9i to setting timeout session ?
>
> - Where read détails error code oracle on the web ?
>
> Thank you for your help.

Go to http://tahiti.oracle.com and look up "PROFILE".

You can either modify the default profile or create your own and assign it to specific users.

CREATE PROFILE developer LIMIT
IDLE_TIME 30; You could also add other useful functions such as:

CREATE PROFILE end_user LIMIT
IDLE_TIME 30

PASSWORD_LIFE_TIME 60
PASSWORD_GRACE_TIME 10
PASSWORD_REUSE_TIME 0
PASSWORD_REUSE_MAX 0

FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 2; and more. Check it out.

Daniel Morgan Received on Thu Feb 13 2003 - 10:41:53 CST