View error, but User has been granted permissions

From: Craig J. Fischer <cfischer_at_tyrell.net>
Date: Tue, 28 Feb 1995 00:35:34 GMT
Message-ID: <cfischer.41.0012984E_at_tyrell.net>

I'm currently tyring to figure out an error with some views. Account A owns a bunch of tables. Account B has built some views on those tables. Account C needs to access those views.

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.

If C does not have permission on foo, the error looks like this:

SQL> SELECT * FROM foo

                   *

ORA-00942 table or view does not exist.

which indicates that Oracle can't find "foo". In this case though, if C executes the exact query that makes up the "foo" view, there is no error; i.e., it *can* see all the necessary views and tables in A's account.

BTW, the reason we're doing things this way is because user A is a third-party application's account, B is where we put in-house developed common objects, and user C is a generic end user.

If this makes any sense to anyone, I'd appreciate some help.

Thanks in advance,
Craig Fischer
cfischer_at_tyrell.net Received on Tue Feb 28 1995 - 01:35:34 CET