Re: Oracle & UNIX password

I guess you are using an ops$ account in the database to overcome the password requirement when logged into unix, the only way to connect to the data from a client pc is to fully issue the ops$username with the password so when you setup the user with ...

grant connect,resource to ops$username identified by password.

you would use the password issued in the above statement although it will not be required when logging in via unix

regards
Abdul Sheikh

cbf_at_moe.ac.sg (Chong Boon Foh) wrote:

>Our organisation is in favour of single logon to UNIX and ORACLE, ie. user
>connecting to ORACLE is authenticated by UNIX operating system.
 

>When I logon to UNIX, I am able to connect to ORACLE using SQL*PLUS in the
>server without issuing password.
 

>However, I encounter problem when I run SQL*PLUS in client workstation to
>access ORACLE because I do not have password stored in ORACLE, and the logon
>failed.
 

>Could anyone help solving this problem ?
 

>Thank you very much.
 

>Regards.
 

>--
>===============================================================================
>Chong Boon Foh ÕÅ ÎÄ »ð Computer Services Branch
>Information Systems Officer Ministry of Education
>Telephone : (65) 4709378 Kay Siang Road
>Internet : cbf_at_moe.edu.sg Singapore 248922
>Fax : (65) 4737513
 

> ÄÑ µÃ ¾¡ Ëæ ÈË Ò⣬ µ« Çó ÎÞ À¢ ÎÒ ÐÄ
>===============================================================================
Received on Fri May 17 1996 - 00:00:00 CEST