Sherri
|
| Posted: 08/25/2004, 6:11 AM |
|
Help! :o)
Here is what I want to do. Is this possible?
-Create database containing payroll stub information.
-Use CodeCharge Studio to access the information in read-only format.
******When a user logs in, I only want them to see the records that correspond to their userID, and no others. They will see only their paystubs and not have access to see someone elses.
Is this possible? How would I do this?
Thanks!
Sherri
|
|
|
 |
Sherri
|
| Posted: 08/25/2004, 6:14 AM |
|
Can I connect CodeCharge Studio authentication to Active Directory (Windows 2000)? This would make it so that I wouldn't have to manually enter hundreds of userIDs and Passwords in to the Access database.
Thanks!
Sherri
|
|
|
|
E43509
Posts: 283
|
| Posted: 08/25/2004, 6:29 AM |
|
Yes, you can limit folk by the sql string where clause.
select * from payroll where userid = session.userid
Two ideas ...
You can create your own login screen and ask them for their AD username and password and just do a simple ldap query against your AD. If LDAP returns a value, then use that userID to set CCS userid session variables.
Or put your webpage/server in your AD domain and grant only logged in folk access to this site. Then you can use the CGI variable REMOTE_USER or AUTH_USER to find their login name.
|
 |
|
Sherri
|
| Posted: 08/25/2004, 8:10 AM |
|
Thank you for your suggestions! If you can, please go into as much detail as possible on how to implement your two suggestions. It would be a great help.
Thanks!
|
|
|
|
E43509
Posts: 283
|
| Posted: 08/26/2004, 7:03 AM |
|
What language are you programming in?
|
|
|
|
Sherri
|
| Posted: 08/26/2004, 8:10 AM |
|
I'm using ASP.
|
|
|
|
