I have been burned by the fact that the new FC7 Web authentication is case sensitive on Passwords. So, I wanted to develop a quick little application that will allow me to change users passwords to lower case and to turn that process over to someone else (non-admin) who can do it on request. By this, I mean that if someone calls our help desk and says that they cannot log in via the web, then I can get my help desk person to run this application, locate their name and click on a button to change the password to all lower case and tell the person to try again. It works.
I thought that I would add some more functionality to the application and share the source code with you as I am using two of the new features of RAD v2.5 and FC7 that will allow you to return more than the 256K limit for batch admin replies and the ability to use the List command to return a list of users matching specific name criteria.
There is not much code in this application so feel free to pick it apart.
Installing the application:
Download the self extracting archive PWUtility.exe to your desktop and extract the two files.
Drop the PWUtility.mdb in your \FCRAD\Source directory
Merge the PWUtility.fc settings with your settings file
Run RAD and edit the information in Main routine to meet your needs.
There are two things that should be edited in the source code. Locate the Main routine and edit as described.
1. Restricted List
You can list a number of userids that you do not want anyone to mess with (like your own and that of the admin)
This is the name of a privilege group whereby users belonging to this group will get added functionality.
They will be able to view passwords without the bullets and get an additional option (see below)
User selects one of the options and then types in part of a user's name in the Pattern Match field.
This will return a list of users matching that pattern.
Note: The number of matches returned depends on how large you have set the return value for BatchAdmin command. See the explanation in the Code on the Declarations page.
The user then double-clicks on one of the names, enters the new password (and confirmation) then clicks on change. Of course, I do some checks to make sure that the two passwords are the same.
Set to Lower Case
This option, when you double-click on the name, it presents the password and locks out the two fields. Clicking on Change, will set the password to the lower case version.
Full Access View
With Full Access there is an additional option
- View Password
Now when you choose this option, you get to view the user's password in the display field.
The restricted list is still adhered to however.
Now for the CYA part :)
This source code is offered to you free so use at your own risk. I assume no responsibility should you corrupt data as a result of using it.
I am using it, so I am not having any problems. But then again, I live dangerously.