How to know the users with DATA ADMIN Privilege

[former_member235282]

Dear HANA Experts,

Some users in my SAP HANA database have the DATA ADMIN system privilege.

I am trying to check what are those users one by one since I don't find any option to check them using HANA Studio.

If anyone know how to verify this privileges more practical,  I appreciate your comments.

Regards,

DO

[Former Member]

Hello Daniel,

I believe that the script HANA_Security_GrantedRoleAndPrivileges from the collection of scripts created by contained in note #1969700 will be suited to your needs.

Additionally, the following blog by is also a great starting point for some more HANA security related stuff:

Kind Regards,

Amerjit