Skip to Content
1
Former Member
Sep 27, 2012 at 03:48 PM

Export schema with hdbsql gives privilage errors

522 Views

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!