Building an SQL interface from an ABAP program

[Magic2077]

Dear SAP all,

I am SAP HANA Database Administrator and we my colleagues, we are mananging around 100 HANA Database.

I am looking for a tool to do a HANA usera mass deployment.

Example : an employe is leaving the company and I want to desactive/remove his HANA user from our 100 HANA Databases. Actually, I do have to connect one by one to all 100 Databases and desactive/remove his HANA user.

Do you know if there is tool to start one SQL statement (DROP user Xolduser) to all 100 HANA Databases ?

There is SAP HANA Studio and SAP HANA Cockpit, but I have to connect to all 100 HANA DBs one by one.
There is the DBACOCKPIT from PSM but I also have to connect one by one to all 100 HANA DBs.
Theris is hdbsql client but I also have to connect one by one to all 100 HANA DBs

I would like to build an SQL Interface, a kind of DB02 SQL Editor or DBACOCKPIT.

My goal is :

1. I start a t-code calling a ZABAP Program

2. I create a ZTable with all DBCO connections fields

3. When I start the ZABAP Program, I get a screen and I select all HANA DB in which one I want to start a unique SQL statement.

4. When the HANA Database a choosen (filled out) from the ZABAP Program :

4.1. The DBCO connection are created to connect all selected/choosen HANA Databases

4.2. The SQL statement is executed in all selected/choosen HANA Databases.

The goal is really to avoid connecting to all 100 HANA Databases and start, one by one, the same SQL statement. This is why I am looking for a tool to do HANA DB user mass deployment or to build a ZABAP program to created DBCO connexions and execute a SQL statement in all 100 HANA DB from a unique screen.

Do you already have build that kind of ABAP program ?
Or do you know a tool to do HANA DB user mass deployment ?

Thanks to ALL !

Best regards
PC