Skip to Content
author's profile photo Former Member
Former Member

Role assignment issue in HANA

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 26, 2016 at 12:39 PM

    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?


    saphanasxadmin.jpg (75.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2016 at 08:58 AM

    Hi,

    is the issue still open?

    regards

    Maik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.