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

[saurabh_vakil]

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

[saurabh_vakil · Accepted solution]

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