Mr.Vertigo
18th September 2007, 15:30
Hi to everyone,

I get this error running ora8_maint6.1:

$ ora8_maint6.1 -a y33wo999 -m y33wo999 -p y33wo999 -G baan -P baan
y33wo999 -1 1919 Count not grant role 'R_baan' to user

The Oracle error says:

$ oerr ora 1919
01919, 00000, "role '%s' does not exist"
// *Cause: Role by that name does not exist.
// *Action: Verify you are using the correct role name.

But I have verified the role exists:

SQL> select * from dba_roles where role like 'R_BAAN';

ROLE PASSWORD
------------------------------ --------
R_BAAN NO

And I can grant it inside Oracle:

SQL> grant R_BAAN to Y65WO432;

Grant succeeded.

My idea is that somewhere and somehow Baan "builds" the role name but it does it in a wrong way, infact it use R_baan (and not R_BAAN) between quotes, that it means that in the database it will look for a role with this exact name (R_baan) not taking care of the existing R_BAAN role.

Can someone help me to solve the problem?

Thank you very much (and sorry for my not perfect english...)
Gaetano