🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.programmer
Article #1759

Re: Oracle only works under 'root' ...

#1759
From: Neil Greene
Date: Tue, 06 Oct 1992 17:08
25 lines
1606 bytes
In article <1992Oct6.101636.21539@bernina.ethz.ch> flog@open.ch (Florian  
Gutzwiller) writes:
> I recently installed Oracle 6 under NeXTSTEP3.0. First of all the  
installation  
> software that handles the thousands of diskettes and messages with  
Installer  
> doesn't work anymore. That wasn't a problem, Installer alone did it as  
well.
> 
> But after running the installation script 'oracle.install' and checking  
that  
> all the processes were running, I can only access Oracle from DBModeler  
when  
> logged in as root. 'sqplus' never worked.

DBModeler is going to attempt to find tables owned by the current user  
login id unless you have done the appropriate dwrites to look for tables  
owned by "SYSTEM", "SYS" or any other user.

Have you created additional oracle accounts??  Can you access oracle  
through sqldba or sql*plus??  If so, what accounts are you accessing  
oracle through?

I do not know what tables DBModeler is going to try and read when logged  
in as root.  Have you created additional tables under Oracle accounts??
Technical Details
Message-ID: <1992Oct6.170832.10821@deepthought.uucp>
Path: arc1-ca.pugleaf.net!sparky!uunet!charon.amdahl.com!pacbell.com!iggy.GW.Vitalink.COM!cs.widener.edu!ukma!deepthought!neil
References: <1992Oct6.101636.21539@bernina.ethz.ch>

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.programmer
Path: arc1-ca.pugleaf.net!sparky!uunet!charon.amdahl.com!pacbell.com!iggy.GW.Vitalink.COM!cs.widener.edu!ukma!deepthought!neil
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: Re: Oracle only works under 'root' ...
Message-ID: <1992Oct6.170832.10821@deepthought.uucp>
Sender: neil@deepthought.uucp (Neil Greene)
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
References: <1992Oct6.101636.21539@bernina.ethz.ch>
Date: Tue, 6 Oct 1992 17:08:32 GMT
Lines: 25