Re: Oracle Users

From: anies handoko <ahandoko_at_sampoerna.co.id>
Date: 1998/12/10
Message-ID: <01be23f1$66f56000$ee66010a_at_anies-handsome.sampoerna.co.id>#1/1


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..
>
>
>
Received on Thu Dec 10 1998 - 00:00:00 CET

Original text of this message