Search here for wide range of results..
Loading
Home » Configuration, Siebel Administration, Siebel SQLs & Database, Uncategorized

How to Disable Multiple Sessions for a User ?

15 June 2009 4 Comments

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

Read some more similar posts

4 Comments »

  • admin (author) said:

    Thanks Mike…please register yourself to the blog, to get updates frequently.

  • Vivek (author) said:

    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/

  • Rahul said:

    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?

  • Vivek (author) said:

    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!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.


Verify Code   If you cannot see the CheckCode image,please refresh the page again!