Re: Oracle 7 and UNIX permissions - Help
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