New Level of Security in Sage 300

Posted by EQ Tech on Wed, Jan 27, 2021

New Level of Security in Sage 300

Sage has recently introduced a new level of security to Sage 300 (Accpac).  If you have ever wanted to limit the company list on the drop-down menu at login, that feature is now here!    This enhancement, introduced in version 2018 PU1, hides the company list on the login page until after the User enters their password.  Then, after the password has been entered, only companies to which the User has assigned user authorizations will appear on the list for their selection. 

      Sage 300 Security            Sage 300c security

Previously, all companies were displayed on the list for all users regardless of their security settings.  Users were able to login to a company for which they had no access, and they simply encountered an error message when they tried to click on any of the limited icons on display.  Now, we can eliminate that issue completely! 

Have your Users only see the companies that they need access to by following these simple setup steps:

  • Enable application security for the System database in Database Setup
    accpac security
  • Login to each company as ADMIN (or a user with appropriate rights) and set the User Authorizations for the individual users for each individual company, as per usual.
    sage 300cloud security permissions

  • Browse to the Sage program files directory and open the Runtime folder and locate the a4w.ini file. Open this file in Notepad and find the [Defaults] section.  Set the UserAuthenticatedLisOfCompanies field to 1 (by default it will be 0). 
    sage 300 security permissions

    This is the setting that turns on the function to hide the company list for users without authorizations and forces the entry of the password before showing the list.

This is a great new security feature and also helps limit confusion for your users.  This new feature is available for both Sage 300 and Sage 300cloud (formerly Sage 300c) in versions 2018 or later. If you would like more information or assistance implementing these steps in Sage 300, please give us a call: 760-436-3530 or 866-436-3530 or email support@equationtech.us.

Did you know you can also setup GL security so that your users can access specific GL accounts only?  Check out that feature on our blog, Enhanced Security in Sage 300 General Ledger.

Topics: Sage 300 (ACCPAC), Sage 300cloud, Sage 300 Tips & Tricks

Submit a Comment

Need Help Now?

Request a Call