Take a look at using views. You can assign permissions to the view and have
it select only those students that belong to that teacher. That way you
won't have the added security on the second table. Is this what you were
looking for???
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 6: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
