torys
asked on
Display logged in user name and restrict access based on User ID
Using Dreamwever (ASP VBScript) and Access.
I have a database containing leads that contractors will log into. I have DW's authentication setup where I have a Contractors table containing usernames and passwords (and a field for the custom access level).
All leads have one contractor assigned to it.
Now I'd like to accomplish the following:
1. Be able to display the username of the contractor that is logged in.
2. Only show (filter) the leads for the logged-in contractor (I do not want Contractor A to see the leads of Contractor B).
What would I have to do to accomplish both objectives?
I have a database containing leads that contractors will log into. I have DW's authentication setup where I have a Contractors table containing usernames and passwords (and a field for the custom access level).
All leads have one contractor assigned to it.
Now I'd like to accomplish the following:
1. Be able to display the username of the contractor that is logged in.
2. Only show (filter) the leads for the logged-in contractor (I do not want Contractor A to see the leads of Contractor B).
What would I have to do to accomplish both objectives?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regarding fuzzboxer's comment -- I'm not simply trying to output table info, I'm trying to diplay the name of the person who was just authenticated....there is more to just dragging a field name into the page.
I found a wonderful resource on how to store a session via DW (see http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16563&sliceId=2), however, I am still having difficulty storing the session -- normally I'd set the destionation page as the form action, but my login page shows the form action is a DW declared object (DW"s code that does all of the authenticating).
The login page contains two txt fields, "username" and "pass". On the destination page, I've set
<%session("sessContractor" )=Request. Form("user name")%>, but for whatever reason, the session is still not displaying that username on my destination page.
Any idea what I'm doing wrong?
I found a wonderful resource on how to store a session via DW (see http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16563&sliceId=2), however, I am still having difficulty storing the session -- normally I'd set the destionation page as the form action, but my login page shows the form action is a DW declared object (DW"s code that does all of the authenticating).
The login page contains two txt fields, "username" and "pass". On the destination page, I've set
<%session("sessContractor"
Any idea what I'm doing wrong?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER