Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Controlling the number of users in the database
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
Received on Mon Nov 22 2004 - 15:44:13 CST