修改用户的 schema

create user scott2 identified by scott2 account unlock;

grant connect,resource,select  any table to scott2;

 create or replace trigger set_default_schema
after logon on scott2.schema
begin
   execute immediate 'alter session set current_schema=scott';
end;