Linux:How to grant execute on binaries to user w/o putting in oinstall grp?
cayenneMay 4 2009 — edited May 4 2009Hello all,
I'm having to create a user, both OS and oracle schema...that is going to be used by an application (an auditing 3rd party system, iRecorder by CA). I've created the user, and granted the access it needs on the oracle db side.
I"m also required to give this 'user' OS authentication, and I'm working on that.
The problem is, this 'user' / application will be running on the same box as the oracle software....and when I log it as that user to test connectivity, well, I cannot use the oracle binaries on that box....like SQL*Plus.
I did not put this user in the oinstall group, which owns the binaries on the box, and I'd prefer not to if there is any other way.
Is there a way to grant a user on a Linux/Unix system, permissions to use the oracle binaries? Remember now, this is an application....I'm not sure that forcing it to use a 'sudo' command to connect will work. It will also need to access the tnsnames.ora files.
If this application were running on another machine, it wouldn't be a problem..as that I'd just install oracle client ware on the box...but, since it is on this box...I'm a little lost as to how to approach this without completely giving up the keys to the kingdom if you catch my drift.
tia,
cayenne