Role assignment issue in HANA

[harshadchaudhar]

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

[maik_toth5]

usually the issue is caused by an inactive version of the role. Have you checked that the role is acitve in the repository? Even if it is activate, you can try a re-deploy. Usually this solves the problem. If not, please attach a screen shot and the content of the role.Whith which user are you runnign the procedure?

[maik_toth5]

Hi,

is the issue still open?

regards

Maik

[harshadchaudhar]

Yes. if you have any suggestions, Kindly update me.