How to check SAP HANA Schema Owner.
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”;
it will give following output.
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
Tags : HANA SCHEMA , SHEMA META DATA , SCHEMA OWNER, SCHEMAS View.