Hi All,

Im Pab, just like to know, How can I allow a new user to run specific software like sqlplus.

Scenario:

I have an oradb@database user where i can execute sqlplus /nolog command, but when i created a new user named allan@database the bash says....-bash:sqlplus: command not found.

Thanks

Sounds like a PATH problem. Run these commands as both oradb and allan and post the output

Hi Pab,

The reason you are getting that error message is because the location from where that command runs is not added to his profile's search path.

For example if that command runs from /etc/init.d/ then do the following:

PATH=$PATH:/etc/init.d/
export PATH

This will add path /etc/init.d in his profile. To make these changes permanently edit his .bash_profile file which will be located under his home directory. You might not be able to see it with ls -l, just type ls -A to see .bash_profile file and then edit it using vi or vim. Put the above mention code related to path at the bottom of his .bash_profile, thats it!!!