Monday, November 27, 2017

Attaching Authorizations to Function Profiles

You may need to set up functional authorizations, which involves setting a group of the functions authorized with additional privileges to a function profile code defined elsewhere. Use Functional authorization in the Setup > Users block to accomplish this task. You define functional authorizations by entering pairs (profile codes, function codes) in a record.

  • The grid is only useful when there are specific authorizations for the function. It can either be:
    • Restrictions by site (in this case each line defines authorizations for one or several sites).
    • Or, additional options (one or several lines can be entered depending on whether the authorizations are defined by site).
  • A coherency control is performed on the sites and groups of sites listed in the authorization grid. Therefore, if two sites belonging to different groups to which distinct authorizations have been accorded, an error message is displayed and the entry will not be possible.
  • In order to make the entry of complex cases faster, buttons are available to add, in mass, a set of functions or to merge profiles.
  • Upon saving, the table storing the authorization definitions is saved, but the authorization cross reference table is not updated. This update is made upon exiting the function, if the response is Yes to the message: Update the table AFCTFCY.
  • It’s important to note that the table of the functions profiles manages only the profile code, the authorizations detail by group, or site being managed by the functional authorizations table. But more importantly, for authorizations management, is the site function profile table, which is automatically updated by this function, and also if necessary by the management of groups, companies, and sites.
  • In fact, this table manages in detail the authorizations for each site/profile/function cross reference. Taking into account the number of important functions in the software (several hundred), a folder with many sites may have an AFCTFCY table including a very great number of lines (it has however records of small size). This table is used to obtain good performances during the authorizations management - in particular in the reports. Its update is made upon exiting the authorization update functions. Taking into account the large amount of information to be updated, this function can have a long execution time. It is also possible to launch this operation directly using the associated utility (Validation of the functions).



-
Sage X3 and Sage Software are trademarks of Sage Software, Inc. Microsoft SQL Server, Microsoft SQL Enterprise Manager and SQL Server Management Studio are registered trademarks of Microsoft Corporation. Oracle is is a registered trademark or Oracle Corporation. All other product names used here are trademarks or registered trademarks of their respective owners.
-