ken quirici wrote:
> 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
Are your names, perhaps, non-compliant meaning that they are
mixed case or contain spaces, etc.?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Sep 15 2007 - 14:56:35 CDT
