Skip to Content
0
Aug 24, 2016 at 11:04 AM

View is not allowed in scripted calc. view

40 Views

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

Attachments

Capture.JPG (37.3 kB)