Re: double-quoting table names in TOAD

From: ken quirici <ken.quirici_at_excite.com>
Date: Sat, 15 Sep 2007 10:24:09 -0700
Message-ID: <1189877049.876537.324060@d55g2000hsg.googlegroups.com>

On Sep 15, 12:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
> ken quirici wrote:
> > Hi,
>
> > I was in schema1 (not the actual name) in TOAD -Oracle 9i - and tried
>
> > select count(*) from schema2.table1; (not the actual names)
>
> > I got an 'invalid or unknown table' error, although, as you
> > will see below, schema1 has read access to schema2.
>
> There is no such thing as read access to a schema. Object privileges
> are granted, one at a time, one object at a time.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Thank you for the correction. Any idea why I'm getting the error when I
don't use double quotes around the table name?

Thanks.

Ken Received on Sat Sep 15 2007 - 12:24:09 CDT