Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 106
  • Last Modified:

Creating a session table

Sorry for the novice question here. I'm working on a database design and I'm trying to figure out how to create a session table. For example, if someone logs into the application and then gets timed out, how can I keep their session login information so when they come back to the application it remembers who they are and can take them right back to where they were in the application. Is there an article that explains how to create/store a users session information for retrieval and bringing them back to the application where they were and continuing where they left off?  See the embedded image for the current design.

database diagram
Thanks for any help.
Regards
0
-Dman100-
Asked:
-Dman100-
  • 3
  • 2
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
What 'session' are you referring to?
0
 
-Dman100-Author Commented:
Hi Dave,

Thank you for replying to my post.  My apologies if my explanation wasn't clear.  I was referring to the user session when a user logs into the application.  Does this help explain a little better?
0
 
Dave BaldwinFixer of ProblemsCommented:
Only slightly.  How is the user logging in?  What kind of application?  Is it a web page on a web server?  While web servers set up 'sessions', I don't remember SQL server doing that.  You have to know what is setting up the session before you can capture any info about it.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
-Dman100-Author Commented:
It is going to be a VB.NET web application.  Now, we are still determining if we will store the username/password in a sql table, but it will be a web application on a web server.
0
 
Dave BaldwinFixer of ProblemsCommented:
If you are going to have remote users logging in, a username/password table would be the most common way of doing that.  I don't know how to save and restore ASP session name and info on IIS.  I've done it on PHP but for the data, it would require putting the data into the data base since the session variables disappear when the session expires.
0
 
aneesa83Commented:
The session state provider is configured in your web.config using the sessionState element. For SQL server you set the mode to SQLServer and configure a connection string.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now