The gadget spec URL could not be found

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.
SAP HANA SCHEMA OWNER


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. 

The gadget spec URL could not be found


The gadget spec URL could not be found