Find The Schema Owner of HANA Schema

If you want to know the owner of the HANA schema then you can use the following SQL statement , don’t forget that you need “READ Access” authorization to “SYS” schema to execute this sql.

SELECT * FROM “SYS”.”SCHEMAS”;

Find The Schema Owner of HANA Schema

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.’TRUE’ means; who executes this SQL “has privilege” for related schema.

Leave a Reply


4 − four =

Blogroll