on 2021 Feb 11 1:13 PM
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.
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
No changes,
What detailed information does the guid provide?
User | Count |
---|---|
55 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.