Thursday, 28 May 2020

User creation by modeling after an existing user_HANA

Open an SQL console from HANA studio and type the command 
CALL “SYSTEM”.” USER_CREATION_FROM_MODEL_USER”(?,?,?). Then click on execute. 

In the next screen, fill the parameters like below and then click execute. 
Parameter1—<Model user id> 
Parameter2 – <New user id> 
Parameter3  <New user id>@NA.COM 

You will see the below message at the bottom. This means the user has been created and roles have been assigned successfully. 

Note: Only one user can be created at a time. Execute the call command again to create another user.