Problem with sqlexp

JoeMosc

New Member
I have a site with a runtime of Progress 9 under AIX 5.2.
I need to export some data and for some reason I can't use the dict.p utility (the admin menu is disabled for some reason).
I want to try using the sqlexp utility, but when I try, I get the following message:

Error: [JDBC Progress Driver]:Access denied(Authorisation failed). (8933)

As far as I know, I shouldn't have permission problems. I don't think the database has a password (at least the dict.p utility connects to it without requiring a user/password).

What would cause this error?

Thanks.
Joe
 
Hi.

Connect with User1, no password

Try executing this statement

SELECT * FROM sysprogress.sysdbauth;

It should give you something like this.

GRANTEE DBA_ACC RES_ACC

sysprogres Y Y
root Y Y

Look for the user with "Y" value in the DBA_ACC column

Then try connecting with that user and execute this statement

SELECT * FROM sysprogress.systabauth;

this will give you the names and access rights of each table.
 
Back
Top