Hmmmm....this may be more trouble than I originally thought. Dennis, you are right in how I installed Oracle. I suspected something like this. Hmmm...(oh, I said that already). Let me ponder on this a while.
Thanks to all who responded! -D- On Sat, 07 Jun 2003 14:14:20 -0800 DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Dwayne - My guess is that you installed Oracle under the "oracle" account. > This means the binaries are owned by Oracle. If you do an ls -l > $ORACLE_HOME/bin/oracle, you will probably see the permissions something > like: > -rwsr-s--x 1 oracle dba 42344448 Jul 31 2000 oracle > This means that when the Oracle binary is run it does a "setuid" so that it > runs as Oracle no matter what who the user is. The alternative is to not do > this, which would mean that the Oracle binary would run as the individual > user that started it, but there would probably be permission problems > between the Oracle server process and the user shadow processes. > You may find it simpler to install Oracle under each of these accounts. > This takes up more space, but will allow you to upgrade each database > independently. Or you may find what you are trying to accomplish is more > trouble than it is worth. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Saturday, June 07, 2003 4:04 PM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > Here is what I am trying to do: > > I want to set up three different databases: test1, test2 and test3. > Each database is created by a user named after the sid (i.e. test1, > test2, etc). I want each database to be owned by the user so that when > I run ipcs to look at memory processes, each database is identified by a > different owner. > > Would someone point me in the right direction to accomplish this? > Currently, every database is owned by the oracle account and I am having > a tough time figuring this out. I was hoping to rebuld these databases > this weekend to reflect the above. I am running Oracle8i on RedHat 8.0 > (will be upgrading to RHAS and Oracle9i in a few months). > > Thanks in advance for your help. > Dwayne > > > -- > Dwayne Cox > Corporate Database Administrator > Info Tech, Inc. > 5700 SW 34th Street, Suite 1235 > Gainesville, FL 32608 > > email: [EMAIL PROTECTED] > phone: 352.381.4521 fax: 352.381.4444 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).