Skip to Content
0
Former Member
Mar 07, 2011 at 12:44 PM

Problem with EXPORT TABLE and user privileges

116 Views

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