Skip to Content
1
Oct 21, 2022 at 08:09 AM

SAP HANA USER ADMIN without DROP priviledge

128 Views

Hello,

Is there a possibility to assign USER ADMIN system privilege to the user in HANA DB, but without DROP functionality?

The reason is we want to build a role for 1st level support so they are able to use CREATE and ALTER statements for user creation / password resets etc. but we don't want to give them ability to remove the users (especially with CASCADE option).

Is there a way to create such a role?