I have a problem with grants.
Here is the Situation:
CREATE VIEW SCHEMA2.VIEW as SELECT * from SCHEMA1.TABLE;
GRANT SELECT ON SCHEMA2.VIEW to SCHEMA3;
The Problem is that SCHEMA3 cannot access the view. It gets permission denied.
I dont want to give SCHEMA3 acccess directly to SCHEMA1.
How can I achieve that?