We want to know who all have access to particular schema. SAP provides a system view GRANTED_PRIVILEGES which stores this information.
Requirement: We want to list down all users who can access particular schema.
Prerequisite: We need database user with CATALOG READ or DATA ADMIN system privilege.
- Connect to the required system via HANA Studio
- Open Administration perspective, You can open it from Window -> Open -> Perspective -> Administration Console
- Execute following SQL in SQL console:
WHERE OBJECT_TYPE = 'SCHEMA' AND SCHEMA_NAME = 'NAFTA'
Above SQL will list all users which can access NAFTA schema in SAP HANA.