[ILUG] Newbie Ingres Question

[Glen Gray]

Sounds silly, but the damndist problems usually are.
Are you sure that the_table is in the DB that you are currently
connected to. Sorry if thats too obvious.

I'm not sure that the ingres user will be always have the access to the
table. If it was created by a different user on that DB they may have
only allowed themselves access to it. You might need to do a 
grant select on the_table to ingres or ingres' SQL equivilant. It's kind
of like allowing users to create files that root can't read unless they
set the permissions.

Glen


On 05 Jul 2001 14:15:13 +0100, Andrew Kemmy wrote:
> Hi All,
> 
> Is it possible for user ingres to own a database but not own some of
> the tables within the database ?
> 
> I'm trying to track down an error in a customer's sql query :
> 
> e.g . (as ingres) sql the_database
> * continue
> select * from the_table
> \g
> 
> returns "table does not exist or you do not own the table"
> 
> and yet the owner of the_database is ingres.
> 
> Any pointers welcome please cc me as I am recieving batched ilug mail at
> moment.
> 
> 
> 
> Thanks in advance,
> 
> 
> Andrew Kemmy, SAIR & GNU Linux Certified Professional.
> 
> B.I.C. Systems
> 7 Exchange Place
> IFSC Dublin 1.
> 
> 00 3531 6702900
> 
> http://www.bicsystems.com
> http://www.linuxcertification.org
> 
> -- 
> Irish Linux Users' Group: ilug at linux.ie
> http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
> List maintainer: listmaster at linux.ie