Export schema with hdbsql gives privilage errors

[Former Member]

Hi, I'd like to export whole schema via command line utility of HANA. Following is the command that I've used:

EXPORT "SCHEMA_NAME"."*" AS CSV INTO '/hana/exeini/H01/HDB00/work/baris' WITH REPLACE THREADS 20

Followings are the errors that I get according to user that've used.

SYSTEM user:

* 258: insufficient privilege: Can't export objects in schema SCHEMA_NAME. Can't export procedure SCHEMA_NAME.SN_CREATE_TABLE. user has no privilege on the underlying objects SQLSTATE: HY000

SCHEMA_NAME user i.e. who created the schema:

* 258: insufficient privilege: Can't export objects in schema SCHEMA_NAME. Can't export view SCHEMA_NAME._SYS_SS_CE_138467_TMP. user has no privilege on the underlying objects SQLSTATE: HY000

I checked security manual, and I verified that both user has EXPORT privilege under "System Privileges". Actually, under "System Privileges", both user have all the available privileges. What might be the reason? Thanks!

[former_member597]

I have the same problem. The export does neither work via hdbsql nor via HANA Database Explorer. Does anyone know the answer?

[Former Member]

Any input would be appreciated since I still get this error.

[Former Member]

Hi -

I am also getting same error, any advice..

[Former Member]

you will have to provide user access to SCHEMA under SECURITY->USER->SCHEMA->OBJECT PRIVILEGE->Add Schema Object and grant CREATE ANY access.