Recompile HANA procedure - insufficient privilege: Not authorized

[Former Member]

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_member185165]

Hi Bill,

There is something called as native objects and imported objects.

Native are the ones where the objects are developed in the same system, imported are ones which are developed in different system and transported/imported. So you need to have edit and manage rights on these objects to carry out the changes and activate.

Thanks & Regards,

Vijay

[Former Member]

Thanks Vijay,

Where are these rights?  This is a schema that was imported from a development unit, so repository rights don't really apply - do they?

I tried granting all repository rights (everything on the "package privileges" tab), still does not work.

-Bill