sql-scripts

[Jose Mosquera]

Hi Pals,

For some Oracle sql-scripts in HP-UX 11.0 we are using "sqlplus -s /" where entry show the user password. Is possible read the definition entry in the /etc/passwd file and use the password field to assign it to a varible? Some other trick will be grateful. Pls forget any recommendation about file/directory permissions.

Rgds,

Jose

[A. Clay Stephenson]

The 'trick' is to have the user verified by the operating system.

ALTER USER mickey identified externally;

User mickey will now be verified by mickey's passwd entry.

[A. Clay Stephenson]

I suppose that I should also give you thge rest of this puzzle. The DBA should create a user called OPS$mickey. As UNIX user mickey, you invoke sqlplus / as you are in.