Wednesday, 8 July 2020

HANA database packages privilege issue


Hi All, 

We get complaints from the functional team members that they are unable to search Calculation View/views from packages, while user replace with Data Source. 





Resolution 

Users are facing issues because of the missing package privileges. We can resolve this issue by simply providing root package access to the respective user. 


Privileges granted on a repository package are implicitly assigned to the design-time objects in the package, as well as to all sub-packages. Users are only allowed to maintain objects in a repository package if they have the necessary privileges for the package in which they want to perform an operation, for example, to read or write to an object in that package. To be able to perform operations in all packages, a user must have privileges on the root package.REPO_PACKAGE_ROOT.



It might possible that the user has a package privileges of root package but we need to see which package use is trying to access. 

There are two types of packages 

Privileges for Native Repository Packages


A native repository package is created in the current SAP HANA system and expected to be edited in the current system. To perform application-development tasks on native packages in the SAP HANA repository, developers typically need the privileges listed in the following table:





Privileges for Imported Repository Packages


An imported repository package is created in a remote SAP HANA system and imported into the current system. To perform application-development tasks on imported packages in the SAP HANA repository, developers need the privileges listed in the following table:




Note


It is not recommended working on imported packages. Imported packages should only be modified in exceptional cases, for example, to carry out emergency repairs.


Rupesh Chavan