How to get list of administrator users on the HANA database

SQL that will return all the users that contain privileges related to “admin”:

SELECT (grantee),privilege,is_valid FROM “PUBLIC”.”GRANTED_PRIVILEGES” where privilege like ‘%ADMIN%’

Leave a Reply