Skip to Content
0
Jul 21, 2016 at 09:21 PM

Stored Procedure error while activating - insufficient priv

1061 Views

All,

thank you for reading this question.

I am creating a stored procedure and all or a sudden I hit a road block. I have been creating them just fine and i am not sure why this one would be any different.

I am creating the stored proc on the same package where other sps are created and activated fine.

My stored pro performs a delete / insert / update on a CDS table from a SCHEMA which i have all access INSERT / ALTER / CREATE ANY / DELETE / UPDATE / TRIGGERS / DEBUG you name it.

the stored proc activates fine if i comment out my code.. but that's of no help for me. I have already tried deleting it and recreating it with out any luck. i also created a stored proc with a different name.

on the trace file i see the following error:

error code: 40305, error message: Could not create catalog object: insufficient privilege; Not authorized, object: package ...

as mentioned before, I already have other stored procs on the same package which are working fine.

my stored proc (.hdbprocedure) declaration is as follow (i created it like all others via the wizard):

PROCEDURE "SCHEMA"."path.to::sp"()

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

AS

BEGIN

-- logic

END

I am on SP 11 -- 1.0.112.02 .. this just started happening today

very weird - anyone?