Function Validation
This function allows the global update of information in the tables storing the authorization information crossed-matched between users / functions. It is beneficial when updating the functions dictionary, the company and/or site table, or the functional authorizations table by copy or transfer (in the case of manual entry, the update is carried out automatically).
For performance reasons and to facilitate the use in reports, the authorizations are generated in detail in a cross-referenced table where the key is (the site code, the profile code, the function). This table is updated each time that the profiles, the sites, site groups or the functions are updated. When transfers by copy are carried out, it is necessary to update this information again.
Warning, this table can be large, and there can be a significant quantity of data to update. In effect, if there are 5 different function profiles, and 20 sites, knowing that the software contains several hundred functions, there is a minimum of N*100*5*20 lines in this table (because the super-user profile has access to all the functions for all the sites), plus a line for each combination of user, site, authorized function.