Skip to Content
0
May 05, 2016 at 04:19 PM

Role assignment issue in HANA

549 Views

We are implementing Hybris marketting on HANA DB (HANA SPS11).

As per guide, We have to create one DB user in HANA (TC_USER) and assign role (sap.hana.xs.admin.roles::RuntimeConfAdministrator).

While assigning role, we don't find role (sap.hana.xs.admin.roles::RuntimeConfAdministrator) in our role selection tab.

As per Hybris marketting guide, while executing below command.

CALL _SYS_REPO.GRANT_ACTIVATED_ROLE('sap.hana.xs.admin.roles::RuntimeConfAdministrator', 'TC_USER');

error:

Could not execute 'CALL _SYS_REPO.GRANT_ACTIVATED_ROLE('sap.hana.xs.admin.roles::RuntimeConfAdministrator', 'TC_USER')' in 0 ms 714 µs .

SAP DBTech JDBC: [258]: insufficient privilege: Can only grant activated roles, not sap.hana.xs.admin.roles::RuntimeConfAdministrator