From: jodleren on 5 Mar 2010 11:47
On Mar 5, 6:13 pm, Mladen Gogala <n...(a)email.here.invalid> wrote:
> On Fri, 05 Mar 2010 08:11:13 -0800, jodleren wrote:
> > ORA-01031: insufficient privileges
> If I was out and could respond to usenet messages, what would the above
> line suggest to you?
Since I am ranning out of time I granted all privileges to the user,
and I get the selects there - nice - but the inserts, or calls to
procedures are still missing.
From: John Hurley on 6 Mar 2010 12:17
On Mar 5, 8:35 am, jodleren <sonn...(a)hot.ee> wrote:
> create or replace trigger set_trace after logon on database
> if user not in ('SYS','SYSTEM') then
> execute immediate 'alter session set timed_statistics=true';
> execute immediate 'alter session set max_dump_file_size=unlimited';
> execute immediate 'alter session set sql_trace=true';
> end if;
> when others then
> it works, but the log files states "ORA-04098: trigger
> 'WISE.SET_TRACE' is invalid and failed re-validation"
What do you mean "it works?" ...
Normally system level triggers are not placed in user schemas.
( Check out your message about "WISE.SET_TRACE" aka
Did you install the trigger as SYSDBA?
From: Mladen Gogala on 6 Mar 2010 12:48
On Sat, 06 Mar 2010 09:17:47 -0800, John Hurley wrote:
> Did you install the trigger as SYSDBA?
Hopefully not. NOTHING should ever be installed as SYSDBA.