Sunday, 8 October 2017

How to find the SAP HANA Database Schema Owner

Tags




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).


  1.   SYS                     
  2. _SYS_BI           
  3. _SYS_BIC               
  4. _SYS_REPO  
  5. SAPABAP1
  6. DBACOCKPIT



1 comments so far

This comment has been removed by a blog administrator.


EmoticonEmoticon

Note: only a member of this blog may post a comment.