Search notes:

ORA-01934: circular role grant detected

create role rol_x;
create role rol_y;

OK:

grant rol_x to rol_y;

The following statement causes ORA-01934: circular role grant detected.

grant rol_y to rol_x;

See also