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, Lex. ------------------------------------------------------------------ Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html ------------------------------------------------------------------ -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johnson, George Sent: Tuesday, October 11, 2005 16: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.
BEGIN:VCARD VERSION:2.1 N:de Haan;Lex FN:Lex de Haan ORG:Natural Join B.V. TEL;WORK;VOICE:+31.30.2515022 TEL;HOME;VOICE:+31.30.2518795 TEL;CELL;VOICE:+31.62.2955714 TEL;WORK;FAX:+31.30.2523366 ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 SK=0D=0ANetherlands URL;WORK:http://www.naturaljoin.nl EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx REV:20040224T160439Z END:VCARD