From: jodleren on
On Mar 5, 6:13 pm, Mladen Gogala <n...(a)> 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
On Mar 5, 8:35 am, jodleren <sonn...(a)> wrote:


> create or replace trigger set_trace after logon on database
> begin
>   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;
>   exception
>   when others then
>    null;
>   end;
> /
> 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
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.

First  |  Prev  | 
Pages: 1 2 3 4
Prev: SELECT in problem
Next: RMAN question