ORA-01955: Role "" not granted to the user.

create user tq84_user;

create role tq84_role_direct;
create role tq84_role_indirect;

grant create session     to tq84_role_indirect;
grant tq84_role_indirect to tq84_role_direct;
grant tq84_role_direct   to tq84_user;

alter user tq84_user default role all except tq84_role_direct;

alter user tq84_user default role all except tq84_role_indirect;

drop user tq84_user;
drop role tq84_role_direct;
drop role tq84_role_indirect;