Roles don't work anymore after migration to 7.7

[Former Member]

Hi Folks,

Yesterday we've migrated our test database from 7.6 to 7.7.

We now had 2 problems:

All the triggers have been removed. Not a big issues, since we were hable to recover it from production database

No more role are usable:

Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed

General error;-8047 POS(1) Password required

set role torpedo_user

But there is no password set on the roles !

I've dropped a role, recreate it WITHOUT password, and grant it to a usergroup. Same error...

So i've dropped the role, recreate it with a passord, grant it:

create role balisage_user identified by toto

//

grant balisage_user to admins

//

commit

And the result is:

Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed

General error;-3998 POS(1) Wrong password

set role balisage_user identified by toto

Since all of our applications use roles (one application => one role and one schema), none is usable.

What's wrong ?

TYA

Fred.

[steffen_schildberg]

Hi Fred,

does the problem still exist? What version of the database do you use?

I cannot confirm this error for version 7.7.07.34. But this is a fresh installed version. With this version all roles work as expected.

Regards,

Steffen

[Former Member]

Hi Steffen,

Thanks for your reply.

We use MaxDb 7.6.06.03 32 bits, and i've tried to migrate to 7.7.07.16 32 bits.

We don't have this probleme anymore since 've reinstalled version 7.6, and restored the database.

The "offline database check" didn't find any error on the database.

As soon as i can i'll try to migrate to 7.8 (7.8.01.18 32 bits) to see if the problem persist.

Fred.