Re: Restrict user licences

Hi,

have you checked the init<sidname>.ora file ?

There you can limit the number of concurrent users on the database sid.

If you are running more than 1 applications against the same database instance, this may not help.

Another way to check, is to use a stored procedure which is wrapped (using the wrap command).

This stored procedure increases a number for each connected user. You can use another procedure to be called when the database shuts down or will be started up, which resets the value to 0.

But the easiest way is to use the v$session table to check, how many users are connected etc.

Cheers,

eric

--
codewizarts


i-solutions for tomorrow
"JD" <nongyd_at_my-deja.com> schrieb im Newsbeitrag
news:8spkjn$5af$1_at_nnrp1.deja.com...


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