View over table in different schema

[apedro]

Now here's a description.
I am connected to schema S_A and want a view V_B over table B in schema S_B. I am able to "SELECT COL1 FROM S_B.B" but get an error when "CREATE OR REPLACE VIEW (COL1) AS SELECT COL1 FROM S_B.B", the error is "ORA-00942: table or view does not exist".
Can anyone provide me an idea of what's wrong, please?!
Thanks a lot
André

[sambavan]

Issue

GRANT SELECT ANY TABLE TO user;

Sam

[kris109]

Do you have a synonym in S_A for S_B.table_B?

create synonym S_A.table_B for S_B.table_B;

In addition, ask S_B to grant all object privileges on table B to S_A such as:

grant all on S_B.table_B to S_A;

[Edited by kris109 on 09-03-2001 at 04:44 AM]