Re: PLSQL beginners question

You could try checking for their OS name instead of oracle username.

Raj

On 12/9/05, Paul van den Bogaard <paul_at_vdbogaard.com> wrote:
>
> I have a logon trigger that enables event 10046 for certain users.
> However there are too many users with this same name.
> If I want to reduce the amount of sessions that have 10046 enabled, how
> to extend this in the trigger.
>
> Current idea is:
>
> ....
>
> if user = "USER_OF_INTEREST"
> then
>
> if counter < SOME_VALUE
> enable event
> counter = counter + 1;
> end if
>
> end if
>
> Of course this counter needs to be shared between multiple sessions.
> Would be real convenient of SOME_VALUE could be set independend from the
> the trigger.
>
> Thanks
> Paul
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l