Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Solaris 10g executables - perrmissions

RE: Solaris 10g executables - perrmissions

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Wed, 12 Oct 2005 09:04:42 +0100
Message-ID: <>

        Same mask as always, 022. I will double check that this didn't get messed with, during the install though, thanks. The strange thing, the sqlldr and sqlplus were correct, but all dirs from the top 10g "software-root" down, were set to 750. Even though most of the executables were OK, no one could get to them, then once they could none of the supporting libraries were accesible, then none of the message files, and so on.

-----Original Message-----

From: Lex de Haan [] Sent: 11 Oct 2005 17:48
To:; Subject: RE: Solaris 10g executables - perrmissions

excuse me if I am asking the obvious -- but was your umask setting OK when you installed Oracle 10g? how are the permission settings of the SQL*Loader and SQL*Plus executables?

kind regards,


Steve Adams Seminar

-----Original Message-----

From: [] On Behalf Of Johnson, George
Sent: Tuesday, October 11, 2005 16:39
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.

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.
Received on Wed Oct 12 2005 - 03:07:21 CDT

Original text of this message