Help - Search - Members - Calendar
Full Version: confuse in oracle authentication !
Oracle DBA Forums > Oracle > Oracle Forum
viaphone
sad.gif
Wha I have done as follows :
1 、I have created ORA_DBA group in my WinNT user group
2 、Have added the user 'viaphone' to this group
3 、Set SQLNET.AUTHENTICATION_SERVICES= (NTS) in file sqlnet.ora
4 、Set remote_login_passwordfile = EXCLISIVE in file init.ora

and I login winNT with the user 'viaphone' , and 'viaphone' is not a user
in my oracle , It is should be right for I login Oracle through PL*SQL with
the user name 'viaphone' without the need inputing password ! But I can not , WHY ?
burleson
smile.gif

Hi Viaphone,

Do you want to connect to Oracle without providing a password (external authentication)?

In UNIX, I do it this way:

1 - Add user fred into /etc/passwd

2 - Set init.ora parms:

REMOTE_OS_AUTHENT=true
OS_AUTHENT_PREFIX=""

3 - Set sqlnet.ora parms:

SQLNET.AUTHENTICATION_SERVICES=(NONE)

3 - In Oracle, create the user:

create user fred identified externally;

Here is a good link for creating external authentication for Oracle on Windows:

http://www.winnetmag.com/Windows/Articles/...280/pg/2/2.html
viaphone
All is done , but I still can not login through PL*SQL by the winNT user
'viaphone' without providing a pwd !

I dont know why !
satishleo
Hi,
Oracle cant be wrong, u have created a user on WIN Nt. so you did not createa user in oracle. so there is no user in oracle named viaphone,
try this thing at the sql prompt
SQL>conn / as sysdba

then you would be connected to oracle as sysdba because viaphone is a member of the ORA_DBA group.

hope this helps

thanks

satish
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.