Multi-logon question

  Hi,

I have been asked to make sure that an application user of our APEX application can can only have one active session at any time. That is, to stop all application users from connecting to our APEX application more than once at any point in time time.

To address this problem, I have created a table (lets call it "ActiveUserSessions" ) in our schema to store the application user id and the apex user sessions id, so our custom logon function not only checks the application user credentials, but also populates the table mention before.

My intended solution was that our custom login function would check the table mention above "ActiveUserSessions" to see if the application users which is trying to login has an entry in this table, if she/he did, retrieve the stored apex user session id and check if this session id is valid, which would indicate if it is active. If it was active, then deny access and if it is not active allow the login process to move forward, checking the user credentials, etc.