In this article, we will be share to you on how to find the HANA database schema owner.
We will be using the below command line to get the list of available schemas with the owner.
SELECT * FROM "SYS"."SCHEMAS"
Here, we will be using SQL Editor from the transaction code DB02. Double click on it and from the right panel, paste the above command line.
Click on Execute and you will get the result as similar as below,
- SCHEMA_NAME : The schema name
- SCHEMA_OWNER : The owner of the schema
- HAS_PRIVILEGES
- TRUE : The owner has the privileges to the schema
- FALSE: The owner does not have the privileges to the schema
Alternatively, you can use SQL console in SAP HANA Studio to execute the same activity.
