Elic@elic11>; grant create table to c_i111 identified by c_i111;

Grant succeeded.

Elic@elic11>; create table c_i111.i111_ref_book(x int);

Table created.

Elic@elic11>; grant create session, select any table to c_i111_temp identified by c_i111_temp;

Grant succeeded.

Elic@elic11>; conn c_i111_temp/c_i111_temp
Connected.

C_I111_Temp@elic11>; select * from c_i111.i111_ref_book rb;

no rows selected

C_I111_Temp@elic11>;