Vlad Horsun wrote:

>>>> This would be a very starting point for virtual tables. Rather than
>>>>
>>>> What account do the trigger run under?
>>>>
>>> Under account of user who initiated action. All proposed triggers
>>> fired at moment where valid user account is established
>>>
>> That really won't work for before connect or after disconnect triggers.
>>
>
>
> Are we realy need such triggers ?
>
> Before connect we don't know who tried to connect as user credentials
> not verified. After disconnect have no more info then before disconnect -
> only status of successful disconnection. Both this triggers have no established
> attachment so we can't do something in database within it.
> Therefore i see no value in such triggers ;)
>
> I can be wrong here, of course
>

Totally agreed.

But anyway if someone wants to reject a logon in AFTER CONNECT but
logging, he could use a external table.
Or AFAIU, "autonomous transaction" could be used.


Adriano