RE: non-oracle user sourcing oracle environment

Date: Thu, 4 Mar 2010 10:15:44 -0500
Message-ID: <>

I convinced the server admins to install an oracle client. I did find this after some searching, though.


It does have a disclaimer in the script.

$ECHO "-------------------------------------------------------------------------------"
$ECHO "Disclaimer: The purpose of this script is to relax permissions on some of the"
$ECHO "files in the database Oracle Home so that all clients can access them."
$ECHO "Please note that Oracle Corporation recommends using the most restrictive file"
$ECHO "permissions as possible for your given implementation. Running this script"
$ECHO "should be done only after considering all security ramifications."
$ECHO "-------------------------------------------------------------------------------"
Thanks to all for reminding me of the client.


From: [] On Behalf Of SHEEHAN, JEREMY Sent: Wednesday, March 03, 2010 2:00 PM
To: Andrew Kerber
Subject: RE: non-oracle user sourcing oracle environment

At this point, the server admins don't want us to install any additional software on the server. They didn't give a reason why. Perhaps just laziness? I do like the idea of using the client, tho. It keeps people out of the oracle db home. I'll see if I can lean on that idea more with the server admins.


From: Andrew Kerber [] Sent: Wednesday, March 03, 2010 1:54 PM
Subject: Re: non-oracle user sourcing oracle environment

Some reason why you cant just install the oracle client and let the user use the sqlplus there? On Wed, Mar 3, 2010 at 12:50 PM, SHEEHAN, JEREMY <<>> wrote: Hey all,

I've got an issue trying to get a user to source (and use) sqlplus from an oracle database environment. We're not allowed to use sticky bits. We're not allowed to add the user to the dba group. We're not allowed to use any sudo commands.

I'm running in AIX 5.3.7. Any suggestions?

Thanks in advance!


Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Thu Mar 04 2010 - 09:15:44 CST

Original text of this message