List of HANA users who has dba privilege for auditing

[former_member542926]

Hi

Our audit team wants to know who has admin privilege (all types of admin) in our production HANA database. Is there a script to find the same?

Basically we need a script to find all the list of users in our HANA DB, who has any admin privilege or roles?

Regards

Senthil

[pfefferf]

The answer is depending on what you understand with "all types of admin". Assuming that you mean the different admin system privileges, the following can be an entry point:

select distinct grantee, object_type, privilege from granted_privileges where object_type = 'SYSTEMPRIVILEGE' and privilege like '%ADMIN%'