Problem with EXPORT TABLE and user privileges

[Former Member]

I want to dump the contents of certain tables of my maxDB database as CSV files.

For that I used this export command:

EXPORT TABLE SCHEMA.AREA_CONCEPT

DATA OUTSTREAM 'AREA_CONCEPT.data';

And tried it with the following comands / users:

1. Database-Admin user:

/opt/sdb/programs/bin/loadercli -d FMED1 -u DBA,PASSWORD -cs \;

or even

/opt/sdb/programs/bin/loadercli -d FMED1 -s SCHEMA -u DBA,PASSWORD -cs \;

Result:

ERR -25392

'[SAP AG][LIBSQLOD SO][MaxDB] Base table not found;-4004 POS(24) Unknown table name:AREA_CONCEPT'

2. User, who ownes the database (schema):

/opt/sdb/programs/bin/loadercli -d FMED1 -s SCHEMA -u DBUSER,PASSWORD -cs \;

Result:

ERR -25392

'[SAP AG][LIBSQLOD SO][MaxDB] Syntax error or access violation;-5001 POS(28) Missing privilege:AREA_CONCEPT'

So that I am new to maxDB could someone please explain me, which user rights have to be set to do this? I already tried it for several hours, but without success.

Any help is appreciated.

Version used:

LOADERCLI version 7.6.06.10 on ubuntu 10.10

maxdb linux-64bit-x86_64-7_6_06_10

Yours

Jo Seibert

[Former Member]

Thanks for your help again, but by the time I solved this solution "by hand". I wrote a java program that exports data via JDBC an reimports them into the new MySQL database.

Sorry, but MaxDB and me - we didn't become friends ...

[Former Member]

What is the schema under which you want to export data from a table? You should login to loadercli with this schema user.. Works for me..

Kind regards,

Mark

[Former Member]

Hi Mark,

thanks for your help.

As I wrote under (2.): when I try to export the data with the owner user of the schema, it results in the error:

ERR -25392

'SAP AGLIBSQLOD SOMaxDB Syntax error or access violation;-5001 POS(28) Missing privilege:AREA_CONCEPT'

[Former Member]

What do you get when you execute the following:

loadercli -d <database> -u <schema owner>,password

and manually enter the export command:

loadercli>EXPORT TABLE "SCHEMA"."TABLE_NAME" CATALOG OUTSTREAM FILE '<path>/table_name.catalog' DATA OUTSTREAM FILE '<path>/table_name.data' RECORDS PACKAGE OUTSTREAM FILE '<path>/table_name.export' APPEND

Kind regards,

Mark

[Former Member]

Hi Mark,

I really appriciate your help.

Nevertheless the output for the command you wrote is also:

ERR -25392

'[SAP AG][LIBSQLOD SO][MaxDB] Syntax error or access violation;-5001 POS(28) Missing privilege:AREA_CONCEPT'

If I connect with the same user to sqlcli and do a "SELECT * FROM SCHEMA.SAME_TABLE LIMIT 1" it works!

Thanks for your help.

Yours Jo Seibert

[former_member229109]

Hello,

1. Please review the document at

http://maxdb.sap.com/doc/7_7/44/e34f4d242103ffe10000000a1553f6/content.htm

2. As you know, the Prerequisites for Exporting Data or the Database Catalog:

"You are logged on to the database as a database user.

You are authorized to access the tables that you want to export.

To export a table in PAGES format, you must be the owner of the table."

Please see more details at MAXDB library in the Exporting: Loader Commands section.

Please update the thread with output of the following SQL commands:

'select * from users'

'select * from tables where tablename = 'AREA_CONCEPT'

Regards, Natalia Khlopina

[steffen_schildberg]

Hi Jo,

would you mind to send the snippet of the loader.log file that contains the command and the error message? You find the location of the loader.log file by starting the loadercli without any option. The loadercli will then write the location of that file to standard out.

Regards,

Steffen