Re: Controlling the number of users in the database

In message <6e07b2d5.0411221344.4d6ccd50_at_posting.google.com>, DanO <daniel.ostertag_at_visaer.com> writes
>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.

Do you need to prevent them using the product, or logging on to the database? The two may or may not be equivalent?

>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.
>

You need to consider that a single 'client session' (i.e. someone using your software on a PC) may result in multiple database connections. You can't then limit on sessions, you have to limit on distinct user names and the client can then get round that by people logging in under the same name.

It might be better not to look for a database solution, but to use something like FlexLM
<http://www.macrovision.com/products/legacy_products/flexlm/index.shtml>[1] or other established license manager.

[1] I see they have been taken over by Macrovision and FlexLM is classified as a Legacy product so it might be better to look elsewhere. Try googling for "licence manager". There are lots.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>