Prev: SELECT in problem
Next: RMAN question
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:

snip

> 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
"SCHEMA.TRIGGER_NAME" ).

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.



--
http://mgogala.freehostia.com
First  |  Prev  | 
Pages: 1 2 3 4
Prev: SELECT in problem
Next: RMAN question