Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Setting database owner to sid

Re: Setting database owner to sid

From: Dwayne Cox <>
Date: Sat, 07 Jun 2003 15:36:51 -0700
Message-ID: <>

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!


On Sat, 07 Jun 2003 14:14:20 -0800

> 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.
> -----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
> phone: 352.381.4521 fax: 352.381.4444


Please see the official ORACLE-L FAQ:
Author: Dwayne Cox

Fat City Network Services    -- 858-538-5051
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).
Received on Sat Jun 07 2003 - 17:36:51 CDT

Original text of this message