HELP with view access
Date: Wed, 13 Jul 1994 15:51:40 GMT
Message-ID: <1994Jul13.155140.26686_at_lmpsbbs.comm.mot.com>
Please HELP. I have a two tables, each named the same but owned by different owners. For example, own1.customer and own2.customer. I have a third owner which was granted select access to these two tables. owner3 then built a view on the two base tables. The view is stated as: "create view customer as (select * from own1.customer union select * from own2.customer);". Owner3 can access the view and query against it. I than granted select to the view and the two base tables to user1. user1 can query th
e two base tables but when he tries to query or describe the view, I get an ORA-942 Tbale or view does not exist. Support seems to be stumped. Can anyone help direct me to what may be wrong here?
Lynda Sohl
Motorola - Components Division
ccof50_at_email.mot.com
Received on Wed Jul 13 1994 - 17:51:40 CEST