RE: Solaris 10g executables - perrmissions

        Many thanks to all for the confirmation that it wasn't just me! I
went through Metalinks docs on file permissions and picked my way through
using truss with sqlplus to locate any odd file calls. I finally ended up
with this list below, it's not guaranteed to be perfect, but it at least
allowed by non-dba users to run SQLPlus without error. It's here just in
case it's useful to anyone else.

======================================
cd $ORACLE_HOME
chmod o+rx *
chmod o+r ./lib/* 
chmod o+rx ./nls/* 
chmod 644 ./nls/mesg/*
chmod o+rx ./nls/csscan/*
chmod 644 ./nls/data/*
chmod o+rx ./bin/sqlplus
chmod o+r ./mesg/*
chmod o+rx ./oracore/*
chmod 644 ./oracode/mesg/*
chmod 644 ./oracode/zoneinfo/*
chmod o+rx ./sqlplus/*
chmod 644 ./sqlplus/mesg/*
chmod 644 ./sqlplus/admin/*.sql
chmod 644 ./sqlplus/doc/*
chmod 644 ./sqlplus/lib/*
chmod o+rx ./rdbms/*
======================================




-----Original Message-----
From: Johnson, George [mailto:GJohnson@xxxxxxx] 
Sent: 11 Oct 2005 15:39
To: oracle-l@xxxxxxxxxxxxx
Subject: Solaris 10g executables - perrmissions



        We are setting up 10g and testing upgrades from our 9i databases.
One of the strange quirks I have noticed is that the default permissions on
the 10g software are a lot tighter than previous versions. 

        We have several auto-loader type users with very limited OS
privileges, they can no longer execute SQL*Plus and sqlldr, under 10g, but
can still access the 9i executables OK. Has anyone else run into this
problem on the Solaris platform? Looks like only members of dba group can
now access the software, I not going to grant dba just to get access to
sqlplus.

        Any pointers, no matter how obvious, appreciated.


****************************************************************************
This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system. E-mail
transmission cannot be guaranteed to be secure or error-free as information
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete,
or contain viruses.  The sender therefore does not accept liability for any
errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version. This message
is provided for informational purposes and should not be construed as an
invitation or offer to buy or sell any securities or related financial
instruments. GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.
****************************************************************************

--
http://www.freelists.org/webpage/oracle-l


****************************************************************************
This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses.  The sender therefore does not
accept liability for any errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.
****************************************************************************

--
http://www.freelists.org/webpage/oracle-l

Other related posts: