Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 04:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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