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

"niz" <niz@infidel.freeserve.co.uk> a écrit dans le message de news: 1182828827.428674.271740@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

In message <46809214$0$26930$426a34cc@news.free.fr>, Michel Cadot
<micadot{at}altern{dot}org@?.?.invalid> writes
>
>"niz" <niz@infidel.freeserve.co.uk> a écrit dans le message de news:
>1182828827.428674.271740@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;
>
>
Also *.os_authent_prefix=' ' looks as if it has a space in it. It needs
to be an empty string. ''

--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>