Re: Oracle 7 and UNIX permissions - Help

From: Ali Guidoum <aguidoum_at_emirates.net.ae>
Date: 1996/04/04
Message-ID: <31625999.1147273_at_emirates.net.ae>#1/1


On 29 Mar 1996 13:58:07 -0800, bagley_at_zimmer.CSUFresno.EDU (Elizabeth Bagley) wrote:

>I have an Oracle 7 system running under Solaris, but have been unable
>to make the databases available to any user on the machine other than
>"oracle", the software owner. As suggested in the install docs, the
>files in the dbs directory are 640 and owned by "oracle" with a group
>ownership of "dba".
>
>When I temporarily added my UNIX login to the group "dba" and changed the
>permissions of the files in the dbs directory to 660, I found that I _was_
>able to access the databases. I'm pretty sure this isn't the way to go,
>since I don't want for everyone to have "dba" access....
>

>Does this sound like a familiar problem to someone? Any pointers?
>
>Greatly appreciative of any help,
>Elizabeth
>--
>==================================================================
>Elizabeth Bagley PHONE: 209-278-3923
>Systems Administator, CCMS FAX: 209-278-4660
>California State Univ., Fresno http://www.csufresno.edu/Elizabeth

In order to address the above problems you have to do two things

In the .profile file of the user basically add to the PATH the full directory path to /oracle/bin.
(Basically the profile file PATH from the ORACLE OWNER may be copied and the unncessary once may be removed..

Secondly you have to , as a DBA user

1.Create an oracle user and password for him

2.Grant access on whatever tables that you want to him.

Hope this helps.

Sindhu Received on Thu Apr 04 1996 - 00:00:00 CEST

Original text of this message