CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

how to created LOGON trigger

edited Feb 25, 2014 10:50AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered

hi,

I have this trigger, but can't  to locate in sqldeveloper,

TRIGGER SYS.user7_login_trigger
  AFTER LOGON ON USER7.schema
  BEGIN

EXECUTE IMMEDIATE 'alter session set timed_statistics=true';
EXECUTE IMMEDIATE 'alter session set max_dump_file_size=unlimited';
EXECUTE IMMEDIATE 'alter session set tracefile_identifier=''USER7'' ';
EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever,
level 12'' ';

1_created LOGON trigger?

thanks

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