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
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