Skip to Content
0

Error converting database SQLA 9.0 to SQLA 17.0

May 06 at 04:32 AM

66

avatar image

I am trying to upgrade the database being used by our client from SQL Anywhere 9.0 to SQL Anywhere 17.0

I followed the instructions provided on http://dcx.sap.com/index.html#sqla170/en/html/81591cfe6ce210149f0889139dc8d91f.html however I was faced with an error:

  • ***** SQL error: Permission denied: you do not have permission to select from "SYSUSERPERM"
  • An error occurred while attempting to unload the database 'C:\Users.......

Any one got any idea what might be wrong?

Kind regards,

Pau

error.jpg (124.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Chris Keating
May 07 at 03:08 AM
0

You are using an user, MOSIAPPS, that does not have permissions to execute the view SYSUSERPERM. You should be using an user with DBA authority.

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Hi Chris.

Is there a way to add a DBA user to this database even without another DBA user access? This is because the DBA credentials were not documented five years ago and there seems to be no way for us to recover the DBA user for this database.

0

Just to add to me inquiry, if I need to add a DBA user, that means I should only use SQLA 9 to do this, right? I could not add a DBA user using SQLA 17?

0
Juan Paulo Mendoza

DBA authority is required for SQLA17 to read the old database.
However, MOSIAPPS did not have DBA authority.
If you can use another user with DBA authority, SQLA9 is not necessary.

0

Hi Koichi.

Is there a way to add a DBA user to this database even without another DBA user access? This is because the DBA credentials were not documented five years ago and there seems to be no way for us to recover the DBA user for this database.

0
Juan Paulo Mendoza

Unfortunately, I think that DBA authority is required to add DBA user.
BTW,
Would you tried connecting by the default DBA user?
(UID=DBA;PWD=sql)

0

I have just tried connecting using those credentials, sadly I can't connect.

0

If you or your customer have a support plan, you may want to discuss this with support to see what options might be available.

0