Copy User's role and privileges from One instance to Another

[Former Member]

Hello All,

We have created a user AdminXX in one of our Hana instance hanaXX which is on Hana SP 6. We are now migrating to new instance Hana YY which has SP7.

My question is how can I create the same user AdminXX in the new instance ? Is there a command to export all the properties of this user, so that I can run that SQL in new Hana instance to create the a user with exact same roles and privileges ?

Thanks in advance for your help.

[sunny_pahuja2 · Accepted solution]

Hello,

I don't see if this is supported. You can refer to below discussion for more information.

However, Starting from SP7, you can copy users in the same instance.

Thanks,

Sunny