CREATE USER USER1 IDENTIFIED BY USER1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
grant create session to USER1;
grant select any table to USER1;
grant select any dictionary to USER1;
CREATE USER USER1 IDENTIFIED BY USER1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
grant create session to USER1;
grant select any table to USER1;
grant select any dictionary to USER1;