Re: Oracle 7 and UNIX permissions - Help

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....

--
Elizabeth:
Make certain that the file protections on the directory defined as 
$ORACLE_HOME are set such that the whole world has read and execute 
privileges. To do this go one directory level ABOVE $ORACLE_HOME and 
issue the command:    chmod 755 <$ORACLE_HOME directory name>
This may solve your problem.
Bob
-- 
========================================================================
  Bob Manieri                           email : bmanieri_at_ford.com
  Database Administrator                voice : (610) 584-7085
  Ford Electronics, Lansdale, PA        pager : (609) 342-0314
========================================================================
  Business is war....information is the high ground.  - J.Abrahamson
  ...we can deprive the enemy of the high ground.  - J. Buford
========================================================================