Re: whos logged in when

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.

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 Wed May 09 2001 - 11:09:06 CDT