3209661 - FAQ: HANA Cloud Database of SAP Datasphere

Questions about HANA Cloud Database of SAP Datasphere.

1. Is it possible to have access for user DBADMIN in SAP Datasphere's HANA Cloud? / How to get DBADMIN database user for SAP Datasphere?
2. Is it possible to use DBADMIN to grant Database Analysis user other privileges in Database of SAP Datasphere?
3. How is it possible to change SAP Datasphere's HANA Cloud parameters when there is no DBADMIN database user?

SAP Datasphere

Q1: How to get DBADMIN database user for SAP Datasphere's HANA Cloud Database?

Although SAP Datasphere runs on HANA Cloud, the HANA Cloud database access is restricted and limited.
All relevant database manipulation scenarios should be performed using either:

• Open SQL Schema/Database User (space-level)
• Database Analysis User (tenant-level)

For more details, refer to User Management on the SAP Help Portal.

Q2: Is it possible to use DBADMIN to grant Database Analysis user other privileges in Database of SAP Datasphere?

No, SAP Datasphere is designed so that the DBADMIN user is NOT required.
Generally, database users do not need extra authorizations. If specific permissions are needed, the recommended approach is to manage them within SAP Datasphere Administration rather than extending database user privileges.

Q3: Is it possible to change SAP Datasphere's HANA Cloud Database parameters?

This is not possible, by design. SAP Datasphere's HANA Cloud parameters follow the standard values defined for all SAP Datasphere customers.
However, if a parameter adjustment is necessary, you can submit a request via SAP case. The request needs to include:

• A full description of the proposed change
• The business case and justification (background reasoning)

Each request will be review and validated before change.

• User Management
• Predefined Database Roles

authorization, HANA, roles, ADMIN, database, DP Server, database tuning, limitation, restriction , KBA , DS-SM , Space Management , How To