| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Setting database owner to sid
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 servicesto: [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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: [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 - 16:36:32 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |