Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!tut.cis.ohio-state.edu!ucbvax!mtxinu!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: Re: question about ingres star
Message-ID: <3047@rtech.rtech.com>
Date: 3 Jul 89 12:08:55 GMT
References: <25368@shemp.CS.UCLA.EDU>
Sender: news@rtech.rtech.com
Reply-To: robf@squid.UUCP (Robert Fair)
Distribution: usa
Organization: Relational Technology, Inc.
Lines: 34

>I was trying to add a node "ipswich" to a distributed database "navy/d"
>and got the following error message :
>
>INGRES ERROR: 26802  User does not have permission to use one of the flags.
>INGRES ERROR: 26002  Above error from Node: IPSWICH  Database: DBDB
>Request Terminated by Errors
>
>I am the owner of this database and should have the permission to
>add other nodes to coordidator node. Also, INGRES/NET works fine for
>me since I can issue  "rtingres nodename:navy/d" from ipswich to
>remote access navy/d on the coordinator site.

If  you are trying to do "ADD NODE" for "IPSWICH" the problem is likely
to be that your effective INGRES user (ie STAR/NET login from coordinator site) 
on the IPSWICH machine doesn't have "Update System Catalogs" privilege 
(See  ACCESSDB). 

ADD NODE works by adding information to  the system catalogs in the database 
database (dbdb) for the remote node so it knows about your distributed database
on the coordinator node.

Since updating system catalogs is a privileged operation, it can fail
with the above error if you don't have it (The actual error comes because
STAR starts up a backend on the IPSWICH machine with the +U flag to
update the system catalogs, and you're  not allowed to use +U unless you
have "Update System Catalogs" privilege.)

There are other remote possibilities why its failing, but this is by far the
most likely.

>- Andy
>
Robert Fair
RTI Technical Support