Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Recompile HANA procedure - insufficient privilege: Not authorized

I am running HANA 1.0.73.

I have imported a delivery unit into HANA which has created a schema TEST_SCHEMA that is owned by _SYS_REPO.  All the objects in that schema are owned by user X.

I then created user Y and granted all privs (create any, select, insert, update, etc.) on TEST_SCHEMA to user Y.

When I try to recompile any procs in that schema as user Y I get: insufficient privilege:  Not authorized.

So even though I have all privs on the schema containing the procedure - do I still need to be the actual procedure owner in order to recompile it?

I can drop the proc and recreate it no problem, but I cannot recompile it.

Is this expected behavior or am I missing a privilege?

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question