Janine,
It sounds like you won't need a second login. Since you know the teacher ID after the
first login, can't you run a dynamic query that displays only those students that
attached to a particular teacher ID?
Perhaps I'm misunderstanding your scenario....
Alec
> -----Original Message-----
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 8: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
