Re: Need help in Unix and Oracle's password!

dlm_at_dlogics.dlogics.com (Dave Mausner) writes:

>jiun_at_wam.umd.edu (Jiun H. Lai) writes:
>>Can anyone of you tell me how to use unix password as oracle password when
>>I login to unix system so I can get into sqlplus or sqlmenu without typing
>>the password twice?
 

>In my opinion and experience, a preferable approach is to use operating system
>verification, so that you do not need to specify the oracle password at all.
 

>for each unix username X, create oracle username OPS$X with password Y.
>a good choice of Y is: VALUES 'X', for example:
> grant connect to OPS$X identified by values 'X';

That will generate a security problem:
If someone spots this rule he may use any account, typing ops$x at the Enter user-name: and typing X at the Enter password: prompt.

Badly I did not know a better solution, the problem is, the ops$ passwords have to be unique... :(

Bye,

         Andreas

-- 

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
 Name        : Andreas Bartelt   /   Nickname: Tares
 Organization: Fachbereich 10 Informatik Softwarelab., Universitaet Oldenburg
 EMail       : Andreas.Bartelt_at_Informatik.Uni-Oldenburg.DE
 FTP-Adm/Unix: bartelt_at_aix01.HRZ.Uni-Oldenburg.DE
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*