Friday, June 19, 2009

Logon Trigger Trace

Generate 10046 level 12 traces when you can't do them in session with:

DROP TRIGGER SYS.ON_LOGON_TRACE;

CREATE OR REPLACE TRIGGER SYS.ON_LOGON_TRACE
AFTER LOGON ON DATABASE
WHEN (
USER = 'AGR55'
)
BEGIN
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/

ALTER TRIGGER SYS.ON_LOGON_TRACE DISABLE;

1 comment:

Anonymous said...

top [url=http://www.001casino.com/]online casino[/url] brake the latest [url=http://www.casinolasvegass.com/]online casinos[/url] autonomous no consign hand-out at the best [url=http://www.baywatchcasino.com/]www.baywatchcasino.com
[/url].