Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Roles don't work anymore after migration to 7.7

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question