Good morning.
A small group of us have "inherited" a Spectra project. This project was
started by a developer who has left our team/company.
I realize that some (or all) of the answers to the questions listed below
may in the documentation. However, as we are trying to quickly ramp up, I
thought I would send out an email to see if anybody can point us in the
right direction (or tell us that it cannot be done).
In case it makes any difference, here is the environment that we are using:
- Webserver:
- Windows NT 4.0 Server
- IIS 4.0
- Spectra 1.5.1
- Database Server:
- Oracle 8i
Thanks in advance for your assistance,
Jim.
1) Issue #1 - The passwords in the USERS table in the USERDIRECTORY database
are stored in clear text.
The development model that our client is moving to all of their internal
applications is that passwords (and in some cases usernames) are *not* to be
stored in clear text in a database. As the Spectra application is using
CFA_SECURE (which is encrypted), we cannot easily determine if there is a
way to add password encryption to the Spectra applications. Also, we are
not sure what side effect this would have with logging into the WebTop.
Does anybody have any experience with this?
2) Issue #2 - How do you change a username?
We are trying to standardize all of the usernames to use the client's
established format (first initial then the full last name). We are trying
to do this *without* moving any data around; we just simply want to change
the username. Unfortunately, when you go to modify an existing user within
the WebTop, the username field is disabled.
We have tried to "brute force" the change by manually making the changes
directly to the USERS and USERS_GROUPS tables (in the USERDIRECTORY
database). This would allow the user to log into the WebTop with their new
username. However, we have apparently missed at least one other place where
the username needs to be changed; I say this because when the user tries to
log into the Spectra application itself, we get an url.error equal to
"true". If we change the data in the USERS and USERS_GROUPS tables back to
what it was before, the user is able to successfully log into the Spectra
application.
It appears that the snag is that when you "brute force" the change, the
request.stUserProfile structure is not getting updated.
Any thoughts?
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
