cancel
Showing results for 
Search instead for 
Did you mean: 

DBADMIN user in HANA Cloud does not grant privileges

estebaorr
Explorer
1,603

Hi Community,

I am working with HANA cloud and I have observed that the DBADMIN user who is theoretically the database administrator cannot grant certain roles or privileges to other users.

Why does this happen?

Best Regards.

View Entire Topic
dvankempen
Product and Topic Expert
Product and Topic Expert

Hi Esteban,

The database “super” user for SAP HANA Cloud is not SYSTEM but DBADMIN. This database administration account has the same system privileges as SYSTEM expect for one: USER ADMIN.

The SYSTEM user, just like the system database associated with our tenant database, is reserved for use by SAP.

DBADMIN is the user group administrator of the DEFAULT user group and can perform most of the user administration tasks like creating users, assigning roles, etc.

As DBADMIN lacks the USER ADMIN privilege some user administration SQL commands have been replaced by stored procedures.

See

estebaorr
Explorer

denys.kempen thanks for the answer,

observing the DBADMIN user of the DB I see that the system privilege "LICENSE ADMIN" is also missing. at the time of granting roles to other users, I have problems because it indicates that the DBADMIN must have this privilege. In addition to the USER ADMIN privilege, is it normal that the DBADMIN does not have the LICENSE ADMIN privilege either?

Regards

dvankempen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Good observation! The license is included with the service. There is no need to acquire a license for SAP HANA Cloud.

0 Kudos

Hy Denys,

I'm still getting the "insufficient privileges" message when creating

a new user with the DBADMIN in the Database Explorer.

Is something changed in the meantime?

Simmaco

dvankempen
Product and Topic Expert
Product and Topic Expert
0 Kudos