Re: cannot log on using "default username feature"

If you just type "sqlplus /", then you are trying to get an ordinary user to connect to an Instance using operating system authentication.

For that to happen, there must be a user entry in the data dictionary which is equal to your os_authent_prefix + the operating system logon.

So... In your init.ora, you can set os_authent_prefix to pretty much anything you like (although the default is "OPS$"). Suppose it was set in this case to 'BLAH'.

Now... Bertrand Russel logs on to the NT box as (NT) user brussel.

Therefore... provided there is a data dictionary entry for BLAHBRUSSEL, Bertrand will be able to connect in the manner you describe as going wrong. The DBA would have had to issue the command 'create user blahbrussel identified externally' first, of course.

Regards
HJR "Cornelius Zeitlmann" <Cornelius.Zeitlmann_at_autodesk.com> wrote in message news:98q95d$8rd_at_autodesk.autodesk.com...
> Has anyone ever heard of the "default username feature" of an oracle 8i
> server?
>
> I try to connect from a solaris client to a Win2k oracle server doing:
>
> sqlplus /
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Thu Mar 15 10:45:57 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01004: default username feature not supported; logon denied
>
>
> a sqlplus <user>/<passwd> or a sqlplus <user>/<passwd>@<service> does
 work
> !!
>
> Regards
>
>
Received on Sun Mar 18 2001 - 06:36:38 CST