Mass upload of users and roles

[former_member327592]

Hi

Is there any way to assign roles to 500 + users in a easy manner in HANA Studio.

We have more than 500+ users to whom we need to assign Native Hana roles via Hana studio and also need to assign session Client .

Appreciate your suggestions.

Thanks

[Cocquerel]

Hello,

if you want to maintain session client attribute, I guess you have an ABAP system on top of your HANA Database.

In this case, you may use report RSUSR_DBMS_USERS for this purpose (see https://help.sap.com/viewer/c6e6d078ab99452db94ed7b3b7bbcccf/202009.latest/en-US/979bb53553d4443ba20... )

Otherwise, you can create an SQL Script doing a cursor on your list of users and loop over it to perform individual GRANT and ALTER USER statements.
Regards,
Michael