Re: View error, but User has been granted permissions

From: Steve Butler <sbut-is_at_seatimes.com>
Date: Thu, 2 Mar 1995 14:48:59 -0800
Message-ID: <Pine.SUN.3.91.950302082017.17656A-100000-100000-100000-100000_at_seatimes>

On Tue, 28 Feb 1995, Craig J. Fischer wrote:
> Account C has been granted Select on all of A's and B's objects, but when C
> tries to select from one of B's views, an ORA-00942 error occurs, like:
>
> SQL> SELECT * FROM foo
> *
> ORA-00942 table or view does not exist.

Looks like you need a local synonym for foo. Otherwise you will need to code stuff as:

SELECT * FROM B.foo

as 'foo' belongs to 'schema' B.

--Steve

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-464-2905         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |

| Seattle, WA 98111 Packet: Not currently active |

+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Mar 02 1995 - 23:48:59 CET