Hello,
I get following message while creating a sample.hdbprocedure file inside package mypackage from web ide
Could not create catalog object: insufficient privilege; Not authorized
When I write this >>
PROCEDURE "SYSTEM"."mypackage::sample" ( ) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER READS SQL DATA AS BEGIN END;
it successfully activates it but as I write
PROCEDURE "SYSTEM"."mypackage::sample" ( ) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER READS SQL DATA AS BEGIN SELECT * FROM "SYSTEM"."Z_MY_TABLE"; --Added this line END;
It starts giving an error
[16:20:01] Error while activating /mypackage/sample.hdbprocedure:
[mypackage:sample.hdbprocedure] Could not create catalog object: insufficient privilege; Not authorized
In order to address this issue, I added object privilege from Security>Users>Object Privileges Tab and checked for DROP, EXECUTE, DEBUG, ALTER however that did not help.
How to address this issue ? Need Help
Thanks