Home » RDBMS Server » Security » Host Authentication
Host Authentication [message #34302] Fri, 03 December 2004 23:45 Go to next message
suneetha
Messages: 4
Registered: April 2002
Junior Member
Hi,

Is Host Authentication feature supported in Release 8.1.6.0.0 ?
If yes, then my doubt goes like this :

Host Authentication says that, we can create a user in Oracle whose password is
validated by the underlying host system.When the user logs onto the host with a
correct password, Oracle then trusts the host's authentication and gives the
user access to Oracle without providing another password.

My systems host name is 'galaxy'.
so I created a user OPS$galaxy using the following sql statement
SQL>create user OPS$galaxy identified externally;

sqlplus executable in my system is in the following path :     c:orawin95bin
 
Now when I'm trying to connect to Oracle from a host system command prompt,
I encountered the following error :

C:WINDOWSDesktop>c:orawin95binsqlplus /

SQL*Plus: Release 8.1.6.0.0 - Production on Mon Nov 15 12:09:30 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01004: default username feature not supported; logon denied

Enter user-name:

 

              Thanks in advance.....
Re: Host Authentication [message #34334 is a reply to message #34302] Mon, 06 December 2004 09:09 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I'm not familiar with Oracle on windows, but the username would probably need to be galaxy - not the host name. It's worth a try...
Previous Topic: access error with grant and CREATE_GROUP_FROM_QUERY
Next Topic: System grant select on user table
Goto Forum:
  


Current Time: Fri Dec 03 07:09:16 CST 2021