Re: making "sqlplus /" work

"niz" <niz_at_infidel.freeserve.co.uk> a écrit dans le message de news: 1182828827.428674.271740_at_z28g2000prd.googlegroups.com...
| hi,
|
| i want to make "sqlplus /" connect directly into the db without giving
| "invalid username/password" or prompting for username and password.
|
| what do i need to to do in order to achieve this?
|
| i have a unix user scott. i have a db user scott.
|
| i have these relevant oracle db parameters:
| *.remote_os_authent=TRUE
| *.os_authent_prefix=' '
|
| logged in as unix user scott, i want to issue "sqlplus /" and connect
| directly into the db.
|
| logged into unix user scott:
| sqlplus scott/tiger -> works OK
| sqlplus scott -> prompts for password
| sqlplus -> prompts for username & password
| sqlplus /.-> gives ERROR:ORA-01017: invalid username/password; logon
| denied
|
| what am i missing here?
|
| --
| reply to group, email invalid
|

alter user scott identified externally;

Regards
Michel Cadot Received on Mon Jun 25 2007 - 23:12:04 CDT