| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
chmod o+rx * chmod o+r ./lib/* chmod o+rx ./nls/*
chmod o+rx ./bin/sqlplus chmod o+r ./mesg/* chmod o+rx ./oracore/*
chmod 644 ./sqlplus/mesg/* chmod 644 ./sqlplus/admin/*.sql chmod 644 ./sqlplus/doc/* chmod 644 ./sqlplus/lib/*
-----Original Message-----
From: Johnson, George [mailto:GJohnson_at_gam.com]
Sent: 11 Oct 2005 15:39
To: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 11 2005 - 10:40:22 CDT
****************************************************************************
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
 |
 |