SQL Language (MOSC)

MOSC Banner

logon trigger, alter session set current_schema

edited Feb 18, 2010 5:08AM in SQL Language (MOSC) 4 commentsAnswered
 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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center