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
