Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: Controlling the number of users in the database

Re: Controlling the number of users in the database

From: DA Morgan <>
Date: Mon, 22 Nov 2004 19:27:59 -0800
Message-ID: <1101180391.128717@yasure>

DanO wrote:

> I have been tasked with finding a way to control (limit) the number of
> users that log into the Oracle database while using our proprietary
> application product. For example, a client may buy our product and
> purchase a 100 user license. We need a way to prevent the 101st user
> from logging into the database.
> I know about the init.ora params (sessions, processes, and
> license_max_sessions), but these can be changed by a DBA. Plus these
> can be misleading as one connection can spawn several processes.
> Does anyone know of a product or a method whereby I can record a user
> logging onto the database and add to a counter (and do the opposite
> for logoff)? I'm sure a home-written solution could be created using
> event triggers, etc. but I'm hoping not to re-invent the wheel if
> somebody knows of a system, method, or little know parameter that can
> work.
> Thanks,
> Dan

I can't imagine anyone buying your product.

We purchase our operating systems flat fee basis. We don't pay extra when more people log into Linux, or Solaris or HP/UX or AIX. We pay a per CPU price for Oracle. We don't pay more depending on the number of connected users. And the same model goes for all of our other software. What makes you think we want to deal with a company that tries to create its own personal pricing model: Certainly I would never recommend anyone go along with such a plan.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Mon Nov 22 2004 - 21:27:59 CST

Original text of this message