Re: Default username

From: Ron Reidy <rereidy_at_indra.com>
Date: Fri, 14 Dec 2001 14:16:59 -0700
Message-ID: <3C1A6C4B.788DE093_at_indra.com>

Bryan Brouckaert wrote:
>
> Hi,
>
> I'm progaming in embedded SQL on a oracle 9.0.1 database. I want to use
> the default username option (you know usernames als opt$login and no
> password).
>
> When I try to login with SQL*Plus it works fine.
> When I try it via embedded SQL I get an error messag:
>
> ORA-01004: default username feature not supported; logon denied
>
> The oracle help says that this means that it isn't implemented on this
> platform???
>
> My system is SuSE 7.3 Linux.
>
> Does anybody know if its correct that it's not supported in embedded but it
> is in SQL*Plus, or am I making a mistake?
>
> Thanks.
> Bryan.
From metalink...

Edit Sqlnet.ora file to include the following parameter:  SQLNET_AUTHENTICATION_SERVICES = (NONE).  Solution Explanation:

---

 Sqlplus connection is expecting user to be authenticated via  3rd party authentication service. However, you are not using  any authentication services. Setting authentication_service  to NONE eliminates the checking and solves the ORA 1004 error.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.

Received on Fri Dec 14 2001 - 22:16:59 CET