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
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 - 11:31:00 CDT
