topic switch user... in Operating System - HP-UX

switch user...

Bing Wong — Thu, 18 Jan 2007 12:03:13 GMT

I created a regular user called "reguser" and allowed it execute Oracle utilities.

When I logged on using that account and executed the following command, I received password prompt to enter Oracle password. Oracle account is an UNIX account. How can I enable this regular user to switch user to Oracle and not required to enter Oracle password? Your help is always appreciated.

su - oracle - c "/app/db/oracle/u01/oracle/product/9.2.0.1.0/bin/sqlplus /nolog"

Re: switch user...

John Guster — Thu, 18 Jan 2007 12:18:54 GMT

su must combine with appropriate password except current user is root. You might want set up sudo for this regular account to execute this command.

Re: switch user...

James R. Ferguson — Thu, 18 Jan 2007 12:21:55 GMT

Hi Bing:

A non-root user that attempts to use 'su - otheruser' to switch accounts will always be prompted, interactively, for the 'otheruser' password. You can't even redirect a file containing the 'otheruser' password to 'su' to circumvent this.

You will have to find a different approach -- 'sudo' or a C-setuid script wrapper are two approaches.

Regards!

...JRF...

Re: switch user...

Bing Wong — Thu, 18 Jan 2007 12:23:31 GMT

I will explore your solutions.

Thank you James and John.

Re: switch user...

Bing Wong — Thu, 18 Jan 2007 12:38:07 GMT

I will explore your solutions.

Thank you James and John!