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.
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
>> 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
>>>> Thanks in advance,
>>> Andrew Kemmy, SAIR & GNU Linux Certified Professional.
>> B.I.C. Systems
> 7 Exchange Place
> IFSC Dublin 1.
>> 00 3531 6702900
> 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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!