Maybe I'm missing something or don't understand nt/active directories (we
haven't decided which system we'll use but we're leaning toward nt)
authentification. I thought that username and password will be checked
against a database = successful/unsuccessful login. People can be assigned
to group permissions.
My teachers will log in on one system- but how do I "connect" the nt/active
directories login id with the unique number that was given to them in the
2nd database? The teacherID from the nt/active directories login is not the
same as the the 2 fields that make up the teacherID in the db2 database. So
my question is more of designing how to connect 2 dissimilar ids. Do I pass
the variable username. Do I pass the nt Id # and add a field for it in my
other database? Is there a way to add the TeacherID/SchoolID to be part of
the nt login/verification?
Date: Wed, 28 Mar 2001 08:21:10 -0700
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: layered security
Message-ID: <34E9FDD74801D511862A00508B670BD30E87DA@GILEX01>
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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
