Former Member

Problem with SecurityAdmin role after SPS 11 upgrade

Posted on Aug 22, 2016 at 02:34 PM 31 Views

Dear Colleagues,

After SPS 11 upgrade, I realized that the system role "sap.hana.xs.ide.roles::SecurityAdmin" has been turned into a blank role. It no longer contains SYSTEM and OBJECT PRIVILEGES. Now it is an almost empty role.

Please, anyone could tell why this is happening and how it can be solved to be a functional role again?

Before the upgrade, it worked OK and it has SYSTEM and OBJECT PRIVILEGES.

Thanks a lot!

Kevin Olesker

Argentina

Add a comment

1 Answer

Sort by:

Votes

Newest

Oldest

Best Answer

This answer has been deleted.

This answer has been undeleted.

Florian Pfeffer

Posted on Aug 22, 2016 at 04:01 PM

2
Hello Kevin,
the role should work as before, because role "sap.hana.ide.roles:SecurityAdmin" (without "xs" in the name) is granted to the role. Due to a reorganization already with SPS09 the new role was introduced and the old role was adjusted.
Regards,
Florian
- Add a Comment
- Alert Moderator
- Share
Add a comment
10|10000 characters needed characters left characters exceeded
2 Comments
- Florian Pfeffer Former Member
  
  Aug 22, 2016 at 04:36 PM
  
  The version you showed is the "offical" version in SPS11.
  What do you miss?
  Of course just give you access to the web-based "Security Application", but by default it does not allow to grant/revoke privileges.
  For the specific privileges you can check Prerequisites for Granting and Revoking Privileges and Roles - SAP HANA Administration Guide. The list gives you an overview what privileges your user must have to do what he should do. I think that list should you enable to create a corresponding role with the prerequisite privileges which can be assigned to your user(s).
  Regards,
  Florian
  - Like 0
  - Share
  - Alert Moderator
Comment on This Answer

Comment

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.

Rules of Engagement

Know someone who can answer? Share a link to this question.

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

Problem with SecurityAdmin role after SPS 11 upgrade

Add a comment

Assigned Tags

Related questions

1 Answer

Add a comment

Before answering