RE: non-oracle user sourcing oracle environment
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2010 10:15:44 -0500
I convinced the server admins to install an oracle client. I did find this
after some searching, though.
$ORACLE_HOME/install/changePerm.sh
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.
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of SHEEHAN, JEREMY
Sent: Wednesday, March 03, 2010 2:00 PM
To: Andrew Kerber
Cc: ORACLE-L
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.
Jeremy
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Wednesday, March 03, 2010 1:54 PM
To: SHEEHAN, JEREMY
Cc: ORACLE-L
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
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>>
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 10.2.0.4 in AIX 5.3.7. Any suggestions?
Thanks in advance!
Jeremy
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
