logon trigger, alter session set current_schema
Hi all,
i have some logon triggers for database users.
i.e:
CREATE OR REPLACE TRIGGER SYS.t_logon_trigger_for_cakorkmaz AFTER OR REPLACE TRIGGER SYS.t_logon_trigger_for_cakorkmaz AFTER AFTER LOGON LOGON ON cakorkmaz.schema begin execute immediate 'alter session set current_schema=TB'; end; / You can see that when cakorkmaz login current_schema is TB. in this session if i run , select * from user_objects; i see nothing. but schema TB has lots of objects. i m confused. why this happens ? Thanks for ur answers. ON cakorkmaz.schema begin execute immediate 'alter session set current_schema=TB'0