Database Links and OS Authentication

From: Jeff Hunter <jhunter_at_isrv.com>
Date: Thu, 16 Apr 1998 17:26:04 -0400
Message-ID: <3536776B.928172CA@isrv.com>

Greetings all,

I know that I have done this in UNIX but can't seem to get it to work in NT 4.0
using Oracle 8.0.3. I have two instances: OEM and DEV. They both have public (anonymous) database links pointing to each other. I have users on
each of those databases being authenticated at the OS level. (OPS$). When I try to access the database link from any of the OPS$ accounts, I get the following message:

/* -------------------- SNIP ----------------------------*/
C:\WINNT\system32>plus80 /

SQL> select user from dual;

USER

---

OPS$JHUNTER SQL> select * from user_names_at_dev;
select * from user_names_at_dev

                         *

ERROR at line 1:
ORA-01004: default username feature not supported; logon denied ORA-02063: preceding line from DEV

/* -------------------- SNIP ----------------------------*/
Any suggestions?!?!?!?

Thanks in advance
-- Jeff

Jeffrey Hunter               Internet: jhunter_at_isrv.com
Programmer/Analyst           WWW: www.isrv.com/~jhunter
PO BOX 832                   Voice: (724) 284-7325
Butler, PA 16003-0832        FAX: (724) 789-9601

Received on Thu Apr 16 1998 - 16:26:04 CDT