create user testjb identified by test;
grant create session to testjb;

create table tmp_test(test number);
insert into tmp_test values(1);

select * from tmp_test;
--RET: 1

grant select on tmp_test to testjb;

select sys_context( 'userenv', 'current_schema' ) from dual;
--REMEMBER this SCHEMA



--Now LOGON with JbSQL with new user:

select * from tmp_test;
--mmh. doesn't work, so let's change the schema

alter session set current_schema=MEDSOFT;
select * from tmp_test;
--RET: 1

desc tmp_test;
--SQL> desc tmp_test;
--Object TMP_TEST does not exist