Skip to Content
1
Former Member
Jan 03, 2017 at 03:18 PM

HANA XSA Import Privileges to import Data from CSV

649 Views

Hi Experts,

I am trying to import data from a CSV in HANA HDO container.

Altered the indexserver also by enabling the import_export parameter.

I use the same old sql statement as used in HANA XSC:

import from '/mnt/share/data.ctl';

It drops an error saying:

Insufficient Privileges: Not authorized

The CTL is file is correctly built, since whenever i change the schema inside the CTL file it drops an error.

It seems to be some privilege issue since i am running this from SYSTEM user in HANA studio.

Can someone guide how to solve this.

Thanks,

Abhishek.