Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Profile is not working

Re: Profile is not working

From: Cong TANG <lai-tang_at_mycity.at>
Date: Wed, 29 Dec 1999 17:14:32 +0100
Message-ID: <386A3368.9343425D@mycity.at>


You need to set RESOURCE_LIMIT = TRUE in init.ora and restart the database. You can also set this parameter dynamically using the command 'ALTER SYSTEM SET RESOURCE_LIMIT = TRUE;'. The default value of FALSE disables the enforcement of resource limits.

Cheers
Cong Tang

PSINet News Service wrote:

> Hi,
>
> I am working with Oracle 8i Installed on Solaris-OS.
>
> I created a profile clerk
> with connect_time 2 min.
> Idle_time 2 min.
> Concurrent Session 2.
>
> I have assigned this profile with a user tony who has already the
> Default profile.
>
> I logon as tony,
>
> and does the query. It suppose to logout after 2min.
> If the idle_time is more than 2 min. It should
> logout.
> It should not allow me for 3 session for the
> same user
> But, Nothing is working. I don't konw where goes wrong.
>
> can any one help me.
>
> regards
> Antony
Received on Wed Dec 29 1999 - 10:14:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US