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.