Re: Discoverer cannot see rebuilt table

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 30 May 2002 19:54:44 GMT
Message-ID: <3CF68380.9D669DEB_at_exesolutions.com>


Gary H wrote:

> I am using Disc 3.0. I recently had to remove 3 columns out of a
> table and so copied the table into a tmp using create table as
> (select......). I then copied it back to the name of the original
> table (having deleted the original). I have given select privs to the
> appropriate users.
>
> I now find that the users can run Discoverer queries against the base
> table displayed in the EUL but not "composite" views (sorry cant
> remember what this is called - the real world view of the tables)that
> contain the changed table.
>
> Help greatly appreciated.
>
> Regards
>
> Gary.

Think GRANT SELECT ON table to SCHEMA

Daniel Morgan Received on Thu May 30 2002 - 21:54:44 CEST

Original text of this message