2971325 - How to grant SAP_INTERNAL_HANA_SUPPORT role to multiple users

The SAP_INTERNAL_HANA_SUPPORT role contains system privileges (for example, CATALOG READ) and object privileges (for example, SELECT on SYS schema) that allow access to certain low-level internal system views needed by SAP HANA development support in support situations. So, in usual cases, it is not necessary to assign SAP_INTERNAL_HANA_SUPPORT role to business user(s).

In special business environment, you may need to assign SAP_INTERNAL_HANA_SUPPORT role to multiple users. When you try to assign SAP_INTERNAL_HANA_SUPPORT role to the 2nd user, you received the following error.

Could not modify user 'DEMO_1'. SAP DBTech JDBC: [456]: not allowed for this role: grant to more than the preconfigured number (1) of users at a time.

"Image /data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP HANA Platform Edition 1.0 or higher

SAP_INTERNAL_HANA_SUPPORT role, multiple users, not allowed for this role, grant to more than the preconfigured number, internal_support_user_limit , KBA , HAN-STD-ADM-SEC , SAP HANA Security & User Management (Studio) , How To