Creating Users in XS Advanced XSJS or SQL (SAP HANA Express Edition)

[former_member603682]

Hi!

I am using SAP HANA Express and I want to know if it is possible to expose a service to create/modify users in XS Advanced.

I did some research but the only option seems to be create them with the command line or Cockpit. is that all? there is no API to create users?

I am using HANA Express Edition.

Thanks very much.

[Cocquerel]

is there a way to add members in XSA space as "Space Developer" via SQL ?

[thomas_jung · Accepted solution]

Yes you can create XSA business users and assign role collections via SQL. The XSA role collection assignment is just done via User Parameters on the HANA DB user. And to make the user an XSA Business User it just needs at least one Role Collection assigned to it. For example for workshops I mass generate my XSA business users via SQLScript:

https://github.com/SAP/hana-xsa-opensap-hana7/blob/master/db/src/procedures/create_users_mass.hdbpro...

[former_member247105 · Accepted solution]

Thanks Thomas! Great help!

[former_member615732 · Accepted solution]

Hi Thomas,

This is great help!

It looks like those xsa users are still shadow there after I deleted them from xsa cockpit. I run the following command line to list all users for a space,

xs space-users ORG SPACE

role users

SpaceManager XSA_ADMIN, <unknown>

SpaceDeveloper XSA_ADMIN, XSA_DEV, <unknown>, <unknown>, <unknown>, <unknown>,<unknown>, <unknown>

SpaceAuditor XSA_ADMIN

Any idea? Thanks again

[former_member747647 · Accepted solution]

HI thomas:

Can I ask a question how to get xsa business users, not guid code ,we want to get full login name.?

[former_member247294 · Accepted solution]

XSA Cockpit app uses the getXsaBusinessUsers api for displaying users in the UI5 frontend