logon trigger

The motive of this is that if the user logs in as U_SCHEMA, it should display as if the user has logged in as SCHEMA.

Go to OEM grid control(login as system)
Target
database
schema
triggers
login as system user
schema->system
go
edit the 'logon aspire' trigger
include the below lines
if(upper(USER) = 'U_SCHEMA') then execute immediate 'alter session set current_schema=SCHEMA';
end if;

To check
----------------
sql>conn U_SCHEMA/U_SCHEMA;
connected.

sqL>select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') FROM DUAL;
SCHEMA