Skip to Content
0
Oct 07, 2016 at 10:59 AM

Stored Procedure - Could not create catalog object: insufficient privilege; Not authorized

4388 Views

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