Skip to Content

abap user mass synchronize hana user

May 15 at 05:01 PM


avatar image
Former Member

Hello Experts,

I created an ABAP user and I want to map it to HANA user to let it use ABAP DDIC tables in HANA artifacts.

I'm using a multitenant HANA db. I set HANA connection successfully and I can display DMBS user tab in SU01. I ran RSUSR_DBMS_USERS to synchronize users and I got successfull message. I access HANA database via Eclipse plugin using SYSTEM user but I don't display ABAP user in Security/Users.

Please, help me.

Thansk in advance for your help

10 |10000 characters needed characters left characters exceeded

Please can you add some more details to your question, e.g. the settings of the DB connection you are using, screenshots of the tenant DB security/users area ...

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Thomas Jung
May 16 at 12:09 PM

I can see from your Studio connection that you are logged into the SYSTEMDB. Most likely your ABAP system isn't installed in the SYSTEMDB but into a tenant. Each tenant (and SYSTEMDB) have completely separate user stores. So you need to create a connect in HANA Studio to the correct tenant. The SQL Port from your ABAP connection details would seem to confirm this situation. It ends in *15 which would indicate the first tenant. The SystemDB generally ends in *13.

10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 16 at 11:59 AM

Hello Florian, in the following picture you find settings of DB connection.

Following DBMS tab of SU01

Following systemDB security/users area (No tenantDB set)

Thanks a lot in advance for your help. Let me know if you need more information.

Best regards

dbconnection.jpg (47.4 kB)
dbms-user-su01.jpg (121.1 kB)
user-area.jpg (49.0 kB)
10 |10000 characters needed characters left characters exceeded