Skip to Content

Which predefined role to assign for getting ROLE ADMIN system privilege on HANA DB

Hi experts,

Currently my user on the HANA DB contains DB admin authorizations, including all the system privileges. I want that my user should only be able to grant HANA DB roles to already existing DB users and the user should not be able to create/modify DB users. I have read here System Privileges (Reference) that ROLE ADMIN system privilege can be used for this purpose, but for this system privilege is there any specific role that needs to be assigned?

Regards,

Saurabh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 02, 2017 at 06:50 AM

    This has been achieved using the HANA role sap.hana.security.base.roles::XSUserAdmin on the HANA DB.

    Add comment
    10|10000 characters needed characters exceeded