Accessing a table without specifying the schema name
If you want all users to be able to select from the table without qualifying with the schema name, you want to create a public synonym:
create public synonym TEST_EMP for GBO_ARC_SCHEMA.TEST_EMP;If you only want user_b to omit the schema name, you want to create a private synonym WITHIN user_b's schema (that is logged on as user_b)
create synonym TEST_EMP for GBO_ARC_SCHEMA.TEST_EMP;If you insist on not using synonyms, then, after logging in, do a
alter session set current_schema = GBO_ARC_SCHEMA;
On the server roles for the login you are using, simply uncheck sysadmin and serveradmin roles.That should solve it
For Postgres users with the same problem
ALTER ROLE <YOUR_USERNAME> SET search_path TO GBO_ARC_SCHEMA;