SQL> create role My_READONLY;

Role created.

SQL> grant SELECT ANY DICTIONARY, SELECT ANY TABLE to My_READONLY;

Grant succeeded.

SQL> create user test identified by test;

User created.

SQL> grant create session, My_READONLY to test;

Grant succeeded.

SQL> conn test/test
Connected.
TEST> select count(*) from hr.employees;
  COUNT(*)
----------
       107

1 row selected.

TEST> select * from dba_tab_privs where grantee='MY_READONLY';

no rows selected

TEST> select * from dba_sys_privs where grantee='MY_READONLY';
GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
MY_READONLY                    SELECT ANY DICTIONARY                    NO
MY_READONLY                    SELECT ANY TABLE                         NO

2 rows selected.

orclz>
orclz> conn / as sysdba
Connected.
orclz> drop user jw cascade;

User dropped.

orclz> drop role r1;
drop role r1
          *
ERROR at line 1:
ORA-01919: role 'R1' does not exist


orclz>
orclz> create role r1;

Role created.

orclz> grant select any table to r1;

Grant succeeded.

orclz> grant create session,r1 to jw identified by jw;

Grant succeeded.

orclz> conn jw/jw
Connected.
orclz> select count(*) from scott.dept;

  COUNT(*)
----------
         4

orclz>