Janine,
This sounds like a design issue. If you have control of (or if you get work
out) the relationships, then there won't be any need for a tiered login,
just use the attributes of the teacher->class->student relationship to
control access.
Mike
> -----Original Message-----
> From: Janine Jakim [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 5:08 AM
> To: CF-Talk
> Subject: layered security
>
> I need to make a "layered"login to a secure site. We are using a
> SQL2000 database on Windows2000 machine. I assume that I will have the
> user
> authenicate through the active directory and be recognized as being part
> of
> a "group" and sent to a specialized menu. (am I correct in that
> assumption?)
> One group will be for teachers. These teachers will then need to
> access their students and only their students. This info comes from a
> second db2 database. Two fields make up the unique number (teacherID and
> SchoolID). Should I make a 2nd login that will query only their students?
> I
> don't want to "overload" the teachers with logins, but I don't know if
> there
> is a way to put it into the original login.
> Any ideas on how to make this "user friendly"? I do have the
> ability to store the teacher id information into our sql warehouse. does
> that help me any?
> Thanks,
> j
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
