PDA

View Full Version : Create Authorized Users


jwcorsey
01-25-2005, 01:35 AM
I have been adding members to a members' database and then going to the Page/Product Security screen to create a new authorized user. I fill in the information and assign a password, and save the information. I then logout, go to the website and log in as the new user. I can go to the members-only areas of the site and view pages. When I call up the new member's record I can see the record.

However, usually there is a message at the bottom of the record stating that since this is my record I can edit the record. For about the last two months, any new users added cannot change/edit their records. As administrator I can make changes but I would like the members to be able update their own records.

Any ideas on what might be causing this problem?

Older members are still able to edit/update their records with no trouble. Only the newer members cannot.

Cameron Allen
01-25-2005, 10:25 AM
This sounds like a very odd problem, as all users are logged in the same data table. If you have the site data tables module, view it and see if their are any differences in how the records are being recorded. Where there any other changes other than updating the product that you made (changing the way you created new users)? Also, are you using any custom code, or have you done everything through one of the modules?

jwcorsey
01-25-2005, 11:29 AM
This sounds like a very odd problem, as all users are logged in the same data table. If you have the site data tables module, view it and see if their are any differences in how the records are being recorded. Where there any other changes other than updating the product that you made (changing the way you created new users)? Also, are you using any custom code, or have you done everything through one of the modules?

I am just now taking responsibility for adding members to this site from and individual who left suddenly. I have no idea how he added users. I simply read the manual and followed the instructions.

First I went to the udt_members table and added the new member. Next I called up the security option and added the user and password.

I have examined two tables looking for differences.

When I looked at the udt_members table I noticed that the field for auto_security_auth is blank for those individuals who cannot edit their own records.

When I looked at the sec_users table I found that the new users were listed and that the field MD5CODE contained information that resembled the entries for other records. I did notice that the primary key (PRIKEY) for the member in this table was different than the PRIKEY for the same member in the udt_members table.

I'm not sure what else to look for. My biggest concern is that I do not remove everyone else's ability to edit their records while trying to repair/give this ability to the new members.

There are currently about 125 members in the udt_members table. About 10 of them cannot edit their records. Members who dropped out of the club were deleted from time to time. I'm not sure their names were always removed from the sec_users table at the same time. I found a few records for individuals in the sec_users table who were not in the members table.