How to find the SAP HANA Database Schema Owner:
We want to find the owner of SAP HANA Database schema.before that you need read access to "SYS" schema.
How to check SAP HANA Database Schema Owner.
Open SAP HANA Studio open the SQL console and enter the following query.
Execute the 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 the 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 has the privilege for that Schema.
Also, check the user has a privilege for following schema(s).
- SYS
- _SYS_BI
- _SYS_BIC
- _SYS_REPO
- SAPABAP1
- DBACOCKPIT
1 comments so far
EmoticonEmoticon
Note: only a member of this blog may post a comment.