I have a schema called HCR_SCHEMA, in which I have one table called TEST_EMP, and I have a user say USER_A and granted him select on the TEST_EMP table.

I connected as USER_A as tried to execute SELECT * FROM TEST_EMP. Obviosuly it threw me error saying that table or view does not exists.

I know that I havent mentioned schema name nor created a synonym on that table.

Requirement is I would like to refer to that table without creating synonym.. without using schema name and also without altering the session to use current schema after logging in like alter session set current_schema = HCR_SCHEMA;

Is there a possible way to achieve this without doing the above three mentioned options.

Thanks

grant create table, create session, unlimited tablespace
  to data_owner identified by data_owner;

grant create session 
  to proxy_u identified by proxy_u;
   
alter user data_owner 
  grant connect through proxy_u;
  
conn data_owner/data_owner

create table t (
  c1 int
);
insert into t values ( 1 );
commit;

conn proxy_u[data_owner]/proxy_u

select user from dual;

USER         
DATA_OWNER 

select * from t;

C1   
   1