Register Login

Insufficient Privilege: not authorized in SAP HANA multitenant database containers

Updated May 18, 2018

Hi SAP Experts,

While using SAP HANA multitenant database containers and cross-database access in order to access the query data in your system when I tried to access the objects on another tenant database through cross-database queries I got an error message "insufficient privilege: not authorized " despite of having all necessary privileges assigned to me.

Please help me resolve the above issue:


Comments

  • 24 Sep 2016 3:42 pm Abhijeet Mudgal Best Answer

    The issue you are facing is due to the different identifiers for object types (such as schema, view, table, etc) for tenant database involved in your query.
    It can be checked this by running the query given below as user SYSTEM or with a user that has the role SAP_INTERNAL_HANA_SUPPORT on all involved tenant databases:

    SELECT * FROM SYS.P_OBJTYPES_ ORDER BY OID ASC

    If after running the above query you find any difference between the mapping of object IDs to names, then there will be an issue of authorization errors.

    For example,  A tenant database was created before and another tenant database is created after up gradation to a higher service pack. Therefore now the single-container system from an older service pack will be converted into a multi-container system. And all revisions of the SAP HANA Database up to and including SPS 11 are affected.

    There is no workaround for the issue you are facing in the affected revisions that are cross-database queries cannot be used between the involved tenant databases. 


×