Re: Restricting Logins

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 Fri Feb 17 1995 - 17:28:53 CET