How to check SAP HANA Schema Owner.

Home

Objective : We want to know the owner of HANA schema. If you need access to user defined schema then you need to ask the SCHEMA owner to grant you authorization.

Prerequisite: You need read access to "SYS" schema. .

Steps :How to check SAP HANA Schema Owner.

In HANA Studio open the SQL console and enter following query.

SELECT * FROM "SYS"."SCHEMAS";

This output has following three columns  :
SCHEMA_NAME : Name of the Schema.
SCHEMA_OWNER : User ID of the Schema Owner.
HAS_PRIVILEGES : Shows if user is schema owner or has any privilege for the schema or any object within the schema: 'TRUE', 'FALSE'.
It will show TRUE for the user(who is executing this SQL) has privilege for that Schema.

In our example the user has privilege for  following schema(s).

SYS                    
_SYS_BI          
_SYS_BIC              
_SYS_REPO