Which limitations apply to restricted users in SAP HANA Cloud? Note: There are 3 correct answers to this question.

Question

Options

• AThey only have full SQL access via the SQL console.
• BThey can only connect to the database using HTTP/HTTPS.
• CThey cannot connect via ODBC or JDBC.
• DThey cannot create objects in the database.
• EThey can only create objects in their own database schema.

• A
  9% (2)
• B
  68% (15)
• E
  23% (5)

Explanation

Restricted users in SAP HANA Cloud are a special, locked-down user type designed for application access only - they connect exclusively through HTTP/HTTPS (B), which means native database protocols like ODBC and JDBC are blocked (C), and their privileges are so limited they cannot create any database objects at all (D).

Why the distractors are wrong:

• A is the opposite of reality - restricted users have no full SQL access; they cannot freely execute arbitrary SQL or use a SQL console the way standard users can.
• E is incorrect because restricted users cannot create objects anywhere in the database - not even in their own schema. Option E describes a more permissive (but still limited) user type.

Memory tip: Think of restricted users as "web app users in disguise" - they're designed to sit behind an application layer, so they're HTTP-only (like a browser), read/execute focused, and have zero DDL (Data Definition Language) rights. If it involves a native driver or creating something, a restricted user can't do it.

No community discussion yet for this question.