How to Disable Multiple Sessions for a User ?
This issues was faced by a developer, who asked for the solution, so here is something can be done at database level -
[a]
Create an Oracle profile and limit the number of sessions per database user, for example:
sql> CREATE PROFILE <profilename> limit SESSIONS_PER_USER 1;
sql> ALTER USER <username> <profilename>;
sql> ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
Using this approach, please be aware that dead connections will not always be detected by the database immediately, so users might occasionally not be able to login even a single time until a database administrator has killed their session. Also, they will not be able to login to two different computers at the same time.
[b]
Another workaround could be to write a windows program using the FindWindow() or EnumWindows() API functions to make sure that the Siebel Application is not started a second time. Please note that it is out of scope of Siebel Technical Support to provide such a program. This approach however, could fail, if users discover that they can still start the Siebel Application directly, rather than using the custom program.
[c]
Last, but not least, you could use scripting in the application_start and application_close event and keep the status of an active session in the database (or a local file), not allowing two sessions to be started. This again will require manual intervention if the application was not closed down properly.
Readers, please lets us know if there any other way to do this..









Thanks Mike…please register yourself to the blog, to get updates frequently.
This is a test comment for check the http://www.gravatar.com/
its a nice thing..you should also try..you can attach a snap to your email id..which you use for posts in any blog over the internet..
visit this site, and you will know
http://www.gravatar.com/
What if you have used SSO mechanism to log into the Siebel Application, in which case it will not create a Database session everytime user opens up a new session? How can we restrict the sessions in that case?
Restricting based on session is the thing which we expected from Siebel for single session control. But this is not possible in Siebel as of now, hence we had gone for alternative approaches.
Probably in future releases, Oracle might incorporate it..
Leave your response!
Chat with Admin
Comment, Talk, Share
Applet Business Service Simulator Commandline Configuration Database Dedicated Client EAI EAI Queuing Emails Import Object Integration Objects Monitor Agent Oracle Products Outbound Communication Manager Outbound Web Services Screen Menu Icons Scripting Siebel Siebel Bookshelf Siebel Debugging Siebeldev.exe Siebel Download Siebel Integration Siebel Licence Keys Siebel Menus Siebel PPTs Siebel Screen Icons Siebel Session Siebel Setup Siebel Sif Siebel Slides Siebel Task UI Siebel Web Services SoapUI SR Broker S_ESCL_LOG S_ESCL_REQ S_ESCL_STATE Testing Web Services Tips and Tricks User Properties Workflow Workflow Action Agent Workflow Policies XSLT
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Archives
Friend Blogs
If you like the Site..want to Contribute to Site Support
Looking for Trainings
If you are looking for other types of training, check out the training-classes.com directory of workplace skills training seminars
Most Commented
Recent Comments