Re: limit number of connections on oracle account

I've seen such an approach implemented, and it was an unmitigated disaster. Poor old DBA (it wasn't me, btw) was forever having to manually re-set the 'counter table', because the wonderful developers had forgotten about just one small, tiny thing: human nature.

When Users just switched their PCs off at the end of the day, as they invariably did because it was quicker than closing the thing down "properly", a certain log off trigger never fired, and a certain little table entry was thus never decremented.

Every third day, he'd get about 20 phone calls in quick succession around 9.00am as user after user was refused access to the system.

It was a disgrace.

But as you say, YMMV

Regards
HJR "Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns9112B6B01B3DASunnySD_at_24.0.3.73...
> ewong_at_mail.com (Ed Wong) wrote in
> news:a5ae1554.0109041621.1a854f9f_at_posting.google.com:
>
> > I like to know how to limit number of connections of an oracle
> > account. I have an instance with three oracle accounts on it and it
> > want to limit number of connections to, say 50, on one of the
> > accounts. Any help is appreciated.
> >
> > Oracle 8.1.7.2.0 EE
> >
>
> One "simple" way & not necessarily the best would be
> to implement logon/logoff triggers that increment/decrement
> a value in a table. When the value hit the threshold, say
> 50, it terminates the session rather than allowing it to
> logon. The logoff trigger simply decrements the value.
>
> HTH & YMMV!
Received on Tue Sep 04 2001 - 23:07:41 CDT