Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!swrinde!ucsd!nprdc!apple
From: apple@nprdc.navy.mil (Jim Apple)
Newsgroups: comp.databases
Subject: Oracle OPS$ account and unix set-uid programs ??'s
Message-ID: <9746@arctic.nprdc.arpa>
Date: 25 Sep 90 21:34:05 GMT
Sender: news@nprdc.arpa
Reply-To: apple@nprdc.navy.mil (Jim Apple)
Organization: Navy Personnel R&D Center, San Diego
Lines: 18


	I want to use a OPS$ account to log into oracle from a set uid
program.  My program is owned by "super_oracle_person" and set uid to
"super_oracle_person".  "super_oracle_person" has a OPS$ account that works
fine in sqlplus.  But when I execute the program as myself Oracle will not connect.
I checked the processes table and it shows "super_oracle_person"
as the owner of the program. If I switch user to "super_oracle_person"
everything works great.

	Any help would be great.

	Thanks in advance.

Bye.

(619)-553-9276
	Jim Apple 			apple@nprdc.navy.mil
	WB1DOG				...}ucsd!nprdc!apple