SAP HANA Permissions and Ownership

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

This article is based on SAP HANA 2.0 SPS04

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

How to Find Out the Owner of

Remote Source

select * from ownership
  where "OBJECT_TYPE" = 'SOURCE';