Re: Oracle Users
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,
1 ) ;;
Maybe This can help you...
regards,
#####################
clear
typeset -i x=$(eval who | cut -c1-6 | grep 'Login_Name ' | wc -l)
case $x in
9 ) echo " ";
echo "SORRY.......";
echo "You are trying to log in to too many sessions !!";sleep
4;exit;;
esac
clear
#####################
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