In SAP HANA Cloud, who has access to a database object?

Question

Options

• AThe creator and the schema owner
• BThe user DBADMIN and the group owner
• CThe owner and the SAP-owned users
• DThe user SYSTEM and the creator

• A
  78% (39)
• B
  2% (1)
• C
  14% (7)
• D
  6% (3)

Explanation

In SAP HANA Cloud, when a user creates a database object, they automatically become its owner and receive all privileges on it; the schema owner also has implicit access to all objects within their schema - making A correct. Option B is wrong because there is no concept of a "group owner" in this context, and DBADMIN (while powerful) does not automatically receive object-level privileges by default. Option C is incorrect because "SAP-owned users" is not a defined access category for object privileges - SAP internal users have system-level roles, not automatic object access. Option D is wrong because SYSTEM is a special administrative user but does not automatically inherit privileges on every created object; privilege inheritance flows through ownership and schema hierarchy, not through SYSTEM.

Memory tip: Think "Creator + Schema = Access" - the two people naturally tied to an object (who made it and who owns the space it lives in) are the ones with automatic access.

No community discussion yet for this question.