In my application the clients are given a session id which is used to identify the session.
This id is unique for all sessions and if it's used as a argument with the correct stored procedure it will return information.
As the application works right now two computers could request this information at the same time with the same session id. Which means that if some can obtain a session id, they could get access to the same information as the logged in users.
My question is:
How does a generic login function set status to "logged in" for a user account and how can the program differentiate between logged in sessions and not logged in session so it can refuse requests from not logged in clients information?
Hope i have made myself understandable and that someone could give me some help with this problem who have bothered me for quite some time.