Skip to Content
avatar image
Former Member

SAP HANA User creation through ABAP Web Dynpro

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11, 2015 at 02:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2015 at 03:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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?