SAP HANA Permissions and Ownership

This article contains various informations about the permissions and ownership concepts in SAP HANA.

This article is based on SAP HANA 2.0 SPS04

How to Find Out the Current Session User

SELECT SESSION_USER FROM DUMMY;

How to Find Out the Owner of an Object

This explains how to analyze the ownership of objects in a SAP HANA database.

System Views for Ownership Information

There are three system views providing information about that depending on the object you are looking for:

  • OWNERSHIP
  • SCHEMAS
  • ROLES

Remote Source

SELECT * FROM OWNERSHIP
  WHERE "OBJECT_TYPE" = 'SOURCE';