[ZOPE] User Database and ZOPE Security

[David Woods]

Hello,

I have a site which uses a SQL-Server database to maintain usernames
and passwords.  This allows me to create pretty user interfaces to
allow Teaching Assistants to create user accounts without having to
learn ZOPE and which allows me a lot more control over the accounts
they create.  It also allows me to have greater control over the
interface students use for logging in to our site.  The students who
then log in using these accounts are considered anonymous users by
ZOPE.

I also have some videos on my site that, because of confidentiality
issues, must be protected from unauthorized access.  I use ZOPE
security for this. When the students need to access the videos, they
are left logging in twice.

My question is this:  Is there a way to avoid having to have two
separate sets of usernames and passwords?  Specifically, is there a
way to get ZOPE security to validate against my SQL-Server database
instead of its internal acl-users database in allowing access to the
videos?  Are there utilities to accomplish this?  Any suggestions?

Thanks,
David Woods
University of Wisconsin, Madison