Re: Oracle Users

From: Tanasescu Iosif <iosif.tanasescu_at_bellsygma.com>
Date: 1998/12/10
Message-ID: <36709864.6CB859D3_at_bellsygma.com>#1/1


TRy with create profile, and assign the profile to all users you intend to prevent more than 1 connection;
See create profile sintax.

anies handoko wrote:

> I ever have create that script in HPUX v. 10.01 for granting the number of
> user login. I prevent the users to log in the OS HPUX side ... not in the
> ORACLE ..... but this script is working properly.
> here is the script,
> #####################
> clear
> typeset -i x=$(eval who | cut -c1-6 | grep 'Login_Name ' | wc -l)
> case $x in
> 1 ) ;;
> 9 ) echo " ";
> echo "SORRY.......";
> echo "You are trying to log in to too many sessions !!";sleep
> 4;exit;;
> esac
> clear
> #####################
>
> Maybe This can help you...
>
> regards,
> =================================================
> Anies Tri Handoko
> Database Administrator
> IS Dept. -- MIS Division
> PT. HM Sampoerna, Tbk.
> Indonesia
>
> Ph. : (62 31) 8431699 ext. 1242
> Email : ahandoko_at_sampoerna.co.id
> =================================================
> NoviC <novic_at_bi.go.id> wrote in article <74n1f2$67n3_at_indo-news>...
> > First ..Sorry for my English
> >
> > We use for Acounting applicatian with Oracle ver. 7.1.8 and AIX ver.
 3.2.5
> > The server is IBM RISC 6000 with RAID 7137 and HACMP system.
> >
> > My question is :
> > 1. How do we know for user oracle login ?? ( what's the command is )
> > 2. How we can create only 1 (one) user oracle login for 1 (one) terminal
> > only ??
> >
> > Thanks..
> >
> >
> >

--
Iosif Tanasescu
Consultant
The CGI Group Inc.
1800 McGill College, Suite 1600
Montreal, Quebec, Canada H3A 3J6
Tel:   (514) 281-0149
Pager: (514) 580-1708
Fax:   (514) 847-0071
IIS:itanases
E_mail:Iosif.Tanasescu_at_BellSygma.com
Received on Thu Dec 10 1998 - 00:00:00 CET

Original text of this message