Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: whos logged in when
Idiot error! As SYS the trigger works fine, with name, date, et all.
"ok" <nospam_at_newsranger.com> wrote in message
news:CYdK6.7854$vg1.644594_at_www.newsranger.com...
> You are absolutely right about the missing comma. This trigger must owned
by sys
> (login sys dba to create,probably best for the aud tab too, then grant
select
> (or delete) on this tab to youself). FYI, we use 8.16EE.
>
> Good luck.
> __________________
> OK
>
>
> In article <9dblso$t98$1_at_rex.ip-plus.net>, Ian Ledzion says...
> >
> >I tried your script, but dropping the IF THEN... structure - in any case
> >there was a missing comma between 'DBSNP' and 'SYSTEM' so it wouldn't
> >compile. When loggin on as any user I get the following:
> >
> >ORA-00604: error occured at recursive SQL level %s
> >
> >The manual says contact Support, which is nice...
> >
> >"ok" <j_p_x_at_hotmail.com> wrote in message
> >news:tfil3l3s34de58_at_corp.supernews.com...
> >> I don't have 8.1.5 at hand to test your claim, but it works for 8.1.6
on
> >> our AIX, Solaris and NT. Make sure using attribute 'login_user'.
> >>
>
>
Received on Thu May 10 2001 - 02:40:34 CDT