Hi,all!
We test the database upgrade from 11.2.0.3 to 12.1.0.2 that works with the some ERP system.
Updating the database occur normally and without error, but when using an application for create some reports, an error message appears: ORA-01924: role 'my role' not granted or does not exsist.
When I try to assign this role to user directly (not through another role), I get another message ORA-01979: missing or invalid password for role "my role".
Then I try to remove authentication of role: alter role "my role" not identified;, then everything works fine.
Do you have any ideas how to solve this problem without disabling authentication?
Thnx!!!