Hi,
I have created one view VW1 in my local schema USER1. This view VW1 is based on table TAB1 which resides in another schema R3.
Now when I am using my view VW1 in my scripted calc. view as
var1 = select * from USER1.VW1;
it throws authorization error.
--------------------------
I have executed GRANT SELECT,EXECUTE ON SCHEMA USER1 TO _SYS_REPO WITH GRANT OPTION; already
Thanks,
Subbu