Monday, January 15, 2007

oracle tracing

oracle tracing
FLOWS schema flows_010309 has been granted "alter session" & "create any trigger"

SQL> connect flows_010309@rcdb
Enter password:
Connected.
SQL> create or replace trigger login_trigger
2 after logon on database
3 begin
4 execute immediate 'alter session set sql_trace=true';
5 end;
6 /