User John Smith will access two databases created with ASPrunner 5.1. I need for him to log on with a user name that all databases share. Once signed in, i need him to click on the Application he is working and not be prompted for a password again. I will multiple security fields in the users table for seperate applications, so, if he has Option 1 on, he sees that application. Is this Possible?
Yes, this is possible. I recommend to develop a piece of code to be placed to include/header.asp file of each application.
In this code snippet you can use Session("UserID") variable (stores logged user name) to perform a query against the login table to see if this user has permissions to access the current application.
