Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help limiting number of sessions per user
Thank you. You said (indirectely)
ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
and it worked.
Regards
Hort
"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message
news:d84r96$fr7$02$1_at_news.t-online.com...
> Hortich schrieb:
>> Hi, 10g on Redhat. I am reading the following. I want to limit the number
>> of sessions a user can have. The Oracle documentations say this is the
>> way you do it:
>>
>> create profile proftest limit cpu_per_session 100 sessions_per_user 1
>>
>> and then
>>
>> create user testuser identified by testuser profile proftest
>>
>> However I can connect to the database instance as testuser using sqlplus
>> more than once (I tried and 4 different sessions). Any help please. I
>> only want to allow testuser to have 1 session, or any number that I
>> specify in proftest.
>>
>> Thank you
>>
>> Hort
>
> Try in sqlplus
> show parameter resource_limit
>
> Best regards
>
>
> Maxim
Received on Tue Jun 07 2005 - 14:25:17 CDT