Limiting Access to Non-employees
Posted: Mon Aug 08, 2005 6:13 am
Hi, As you may know, I am an Intranet programmer for a certain company. One of the features of this intranet site is to let employees request technical problem by filling up a certain form that includes employee name to be selected from the list. This list are of course taken from local MySQL database used by the side, not the company database, which is MS SQL which is updated all the time.
I intentionally put the names in the list to prevent non-employees, including visitors, or those frankster playing around at the lounge, from posting their fictitious problem. It works fine for a couple of month, but the problem now is when new employees are hired. Their informations, including names, are not always seen by the MySQL database, because it is only copied from company database. Because of this I have to encode them manually for them to fillup the form.
Some said that I have to put a textbox for name input besides the employee list for those persons that are not in the list. But I don't want to do that for it will be the reason for non-employees to add their names and eventually access pages on the site.
What do you think will I do?
I intentionally put the names in the list to prevent non-employees, including visitors, or those frankster playing around at the lounge, from posting their fictitious problem. It works fine for a couple of month, but the problem now is when new employees are hired. Their informations, including names, are not always seen by the MySQL database, because it is only copied from company database. Because of this I have to encode them manually for them to fillup the form.
Some said that I have to put a textbox for name input besides the employee list for those persons that are not in the list. But I don't want to do that for it will be the reason for non-employees to add their names and eventually access pages on the site.
What do you think will I do?