SAP HANA User creation through ABAP Web Dynpro

[Former Member]

Hi Experts,

I am trying to achieve the following:

Create a user on HANA System through code. I have managed to do this for ABAP systems, but I know that Hana systems are a bit different.

In the ABAP systems there are BAPI's to create users, reset their passwords etc.

My question is how can I do this through code, but for HANA system?

[thomas_jung · Accepted solution]

There are SQL statements to do this.  Look for CREATE USER in the online help.

CREATE USER - SAP HANA SQL and System Views Reference - SAP Library

[amol_samte]

Dear Hubert,

I understood your requirement.

We have to create user at HANA DB through ABAP, that means our ABAP written code should hit to HANA.

Well, It can be done  by using ADBC.

For ref. ABAP Keyword Documentation

You should have to pass create user DDL commands as well as DCL commands as suggested by Thomas in ADBC.

e.g.  for creation user 'CREATE_USER user name password, for role assignment GANT role to user name, for activation and deactivate you can use ALTER USER  etc.

-Amol Samte

[Former Member]

The thing is, I do not know what piece of  ABAP code to write to call the procedure (I am working in TR1, version 720) and default db for this system is oracle so I think I will be some kind of RFC. Is there anybody who can give me an example on how to use it?