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

Is Host Authentication feature supported in Release ?
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 - Production on Mon Nov 15 12:09:30 2004

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

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: Wed Aug 10 13:02:51 CDT 2022