Import data from development space to PROD space

[former_member284850]

I developed a multi-module application in HANA 2.0 XSA with three modules hdb module, sapui5 module and node.js module in the "development" space. Then build the project to create the MTAR file and exported it to the local system directory. I deployed the MTAR into the "PROD" space successfully which created all the above mentioned three modules. In the SAP database explorer all the tables of the hdb module contain empty content. I exported the catalog objects from development space as CSV file. When I import the catalog objects into PROD hdb module I get the following error which can be seen from the attached screenshots. Kindly have a check and help on this how to import the data from development space to PROD space which will be very important to the project.

[pfefferf]

As the error message indicates. Your user is missing the IMPORT system privilege to be able to do the import. In addition your user also needs the Insert privilege on the tables.

Please make sure that your user has the necessary privileges.

Regards,
Florian

[former_member284850]

Can you please in detail how it can be done in step-by-step process?

[pfefferf]

Have you already read the documentation about security and privileges?

If not please read it, because there is everything described you need.

If yes and you still have issues, please post the issues you have.

[former_member284850]

Could you please attach and send me the documentation about security and privileges.

[pfefferf]

Official HANA documentation - Using your search engine skills would provide the same information.