create user usr1 identified by usr1 quota 100m on users;

create role testrole;

grant create table, create session to testrole;

grant testrole to usr1;

create table usr1.emp as select * from scott.emp;

SQL> conn usr1/usr1

connected. 

SQL>conn usr1/usr1

ERROR:

ORA-01045: user USR1 lacks CREATE SESSION privilege; logon denied 

Warning: You are no longer connected to ORACLE.

Processing object type SCHEMA_EXPORT/ROLE_GRANT

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role 'TESTROLE' does not exist

Failing sql is:

 GRANT "TESTROLE" TO "USR1"