create user ptms identified by ptmstest default tablespace users tempprary tablespace temp profiles profile2;
grant create table,create session,create view to ptms;
grant select on scott.emp to ptms with grant option;
grant insert on scott.emp to ptms;