Re: Restrict user licences

I already responded to your query a few days ago. Didn't you receive it or didn't you understand it?

The only thing you need to do is set some init.ora parameters. That mechanism being available, there is no reason to develop something, which is not going to work anyway.

Regards,

Sybrand Bakker, Oracle DBA

"JD" <nongyd_at_my-deja.com> wrote in message news:8sps50$c6l$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.
>
> Regards,
>
> 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.
Received on Fri Oct 20 2000 - 12:16:07 CDT