SAP HANA Permissions and Ownership: Unterschied zwischen den Versionen

Aktuelle Version vom 6. Juli 2021, 12:55 Uhr

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

This article is based on SAP HANA 2.0 SPS04

SELECT SESSION_USER FROM DUMMY;

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

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

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

@@ Zeile 1: / Zeile 1: @@
-This article explains how to analyze the ownership of objects in a SAP HANA database.
+This article contains various informations about the permissions and ownership concepts in SAP HANA.
 This article is based on SAP HANA 2.0 SPS04
-== System Views for Ownership Information ==
+== 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:
@@ Zeile 10: / Zeile 18: @@
 * SCHEMAS
 * ROLES
-== How to Find Out the Owner of ==
 === Remote Source ===
-  select * from ownership
+  SELECT * FROM OWNERSHIP
-    where "OBJECT_TYPE" = 'SOURCE';
+    WHERE "OBJECT_TYPE" = 'SOURCE';
 [[Category:SAP]]
 [[Category:HANA]]