Re: Controlling the number of users in the database

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
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)