Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SCO NIS and Oracle/SQLMenu Authentication

SCO NIS and Oracle/SQLMenu Authentication

From: Chriseli de Rama <chriseli_at_hh.bc.ca>
Date: 2000/05/18
Message-ID: <39247AD2.5AB0DDE@hh.bc.ca>#1/1

O/S: SCO OpenServer 5.0.5, NIS enabled as Client Problem: SQLMenu Authentication won't work because of SCO NIS

I would just like to have the explanation I got from the P/A verified if true:
--

There are several levels of authentication happening on your site. The problem is there is a break down between the SQLMenu authentication and the SCO NIS system. This is separate from the Oracle server authentication. Right now there is no problem with the Oracle 7.3.4 sever communicating with your NIS server. However this means all you can do is login through SQL Plus and get the Oracle command line utility which is OK for administration type work, but not terribly usable. The SQLMenu and SQLForms front end is where the problem occurs. When a user tries to log on to the system using the SQLMenu interface the first thing that happens is the program tries to do is obtain some information about the current OS user. ie login name and a list of unix groups they belong to. This is where the problem happens. The system calls that SQLMenu is issuing are either not supported in this version of SCO NIS or they are returning incorrect values. The only work around is to have the username, password, and groups information stored directly on the SCO sever.
--

Is there a workaround on this so that we don't have to have another set of accounts on SCO? Thanks.

Chriseli Received on Thu May 18 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US