Restrict user licences

[Quoted] Does anybody know of a standard method of restricting the number of concurrent users logging into a bespoke Oracle application. A typical scenario would be a company buying a product with 50 user licences, how do I then restrict / control the number of users that log onto the application.

There may be a way in Oracle, Ive come up with a few, for example writing a record to the database, and checking its value every time a user logs on, when the user logs off then the value is reduced. This seems a sure fire method, but what if theres a power cut, then all users will be logged out and the record in the database will still be set to 47, 48, 49, 50 .....

Another method may be selecting a count of the records in the v$session dba table. However, Im sure a good dba will manage to spoof this table.

Users or the DBA must not have any visability of the solution so they can change it.

Does anyone have any standard solution for this issue. All responses gladly received.

Thanks in adavance,

Jonathan.

--
Nongy's Law Also Rule #1
Life is a rat race - always make sure your the one
wearing the white coat.


Sent via Deja.com http://www.deja.com/
Before you buy.