Page 1 of 1

Maximum number of users allowed

Posted: Fri Oct 05, 2007 8:07 pm
by mpshaw15
Hi

I have a client who keeps breaking their license numbers and adding more users onto the system than allowed.

Is there a way I can put a maximum figure on the number of users that can be defined?

Thanks in advance!

Posted: Sun Oct 07, 2007 10:57 pm
by amirtai
Hi

Can you please elaborate what type of setup you have, which product version you are using? If you have two tier setup. There are possibilities to intercept at the application level i.e mid tier by number of application instances or sessions per client through sso/http server. The other way is at database tier level you can limit the number of session by keeping an eye on v$session view. You can write login triggers to control number of sessions in the database.

It was a generic overview if more detail is provided, that could be helpful to provide more specific solutions.

Thanks
Amir

Posted: Sun Oct 07, 2007 11:42 pm
by admin
Hi,
The license agreement is between the organization and Oracle why are you interested to restrict them? Secondly the organization staff will have admin and DBA access to the instances? You have not mentioned what kind of users database or application? Just curious... thanks