Re: Restricting Logins

stroup_at_grove.ops.lmsc.lockheed.com () writes:

don't forget to set the init.ora parameter RESOURCE_LIMIT to true as well, otherwise resource limits are not enforced.

>
>In article <3i1594$sa9_at_indy-backup.indy.net>, bstanek_at_indy.net (Brian
>Stanek) wrote:
>
>> Hey everyone, I was approached with a questions about restricting
>> the logins of a particular account. The situtation is that they want to
>> restrict access into a particular account to a single session. For the rest
>> of the accounts in the database, multiple sessions are allowed.
>
> If you're running Version 7, it's pretty easy. Oracle provides the ability
>to create profiles which are then attached to the Oracle account. Via the
>profile you can control resources such as connect time, CPU utilization
>and number of sessions.
>
>First, create the profile, i,e,
>
> Create profile ONLY_ONE limit sessions_per_user 1;
>
>Then give the profile to the account you want to restrict, i.e.
>
> Alter user Fred profile ONLY_ONE;
>
>
> Hope this helps....judie
Received on Sat Feb 18 1995 - 16:54:08 CET