George, Is this 10g R1 or R2? Thanks From: "Johnson, George" <GJohnson@xxxxxxx> Subject: RE: Solaris 10g executables - perrmissions Date: Tue, 11 Oct 2005 16:38:05 +0100 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/* ====================================== ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________