Setting database owner to sid

2003-06-07 Thread Dwayne Cox
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

RE: Setting database owner to sid

2003-06-07 Thread DENNIS WILLIAMS
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 4238 Jul 31 2000 oracle This means that when

Re: Setting database owner to sid

2003-06-07 Thread Dwayne Cox
Hthis 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

RE: Setting database owner to sid

2003-06-07 Thread Richard Ji
If you are doing this just so you can use ipcs and be able to tell the owner of shared memory and semaphore etc. You should check into sysresv. It can tell you which sid owns what shared memory segments and semaphores. Richard -Original Message- Sent: Saturday, June 07, 2003 7:14 PM