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

BW on HANA - Authorization issue in HANA Studio

Hello All,

Happy New Year and best wishes!

My Scenario:

I have a BW on HANA landscape (schema created in HANA database is BHX and in the HANA Studio I am logged onto the SYSTEM user. In the SYSTEM user, I am able to see the BHX schema.

I created a new user (for administration purposes which should be able to do everything) HANA_ADMIN. Now, I want BHX schema to be visible when I log in using the HANA_ADMIN user. I am able to do this. Secondly, I am not able to view the contents of any table in BHX schema using the SYSTEM user.

Logically, I need to do this, which I already tried but to no avail - Login using SYSTEM user and open the user HANA_ADMIN which was created earlier. assign the necessary default roles (MONITORING, CONTENT_ADMIN, etc.). In the Object Privileges assign a SELECT on schema BHX. I am not able to do this. An error occurs - Üser HANA_ADMIN cannot be modified, Could not Grant privilege SELECT on BHX. You are not authorized to perform the required actions." Isn't SYSTEM user supposed to be having all requisite privleges for activities like these?

Issue:

To use HANA_ADMIN for viewing and doing all necessary activities on BHX schema and use HANA_ADMIN to further create new users and assign respective privileges and roles. And I am unable to use SYSTEM user to perform these tasks for HANA_ADMIN user.

Thank you for your help!

Regards,

kG

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 01, 2014 at 05:34 PM

    Use the BW admin user for the BHX schema to assign right to system and your admin user. System doesn't necessarily have access to all schemes.

    John

    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.