Security Key Code
Visual APS is an application which is installed locally on a PC or in a terminal/citrix server environment. Users are authenticated using either Windows Authentication of SQL Database Authentication. When launching Visual APS for the first time you must first logon as a SQL administrator as tables, views, functions and procedures are created at this time. After the SQL objects are created you will be prompted to assign Visual APS licences for the users of the application. In the User Access screen, you must enter the users windows logon name (excluding domain name) regardless if you are using Windows of SQL authentication or Explicit or Application Role permissions. If you have chosen to use the application role as your security model you can turn the application role on at this stage. The application role is a setting in the application configuration file (visualplanner.exe.config) which resides on each client PC.
This article explains how to:
To configure Microsoft SQL Security for APS Users:
By adding the user/AD group to the db_datareader role, db_datawriter role or db_owner role in the Enterprise Resource Planning database to assign explicit permissions. To grant the roles explicitly follow the steps below.
Where possible use the application role (option 2) as this is the most secure method of providing permissions to users to perfom inserts, updates and deletions in Visual APS. The application role is applied at the time the user logs into the application via the Visual APS Client. The application role may not be suitable in environments where Visual APS has been customised with custom SQL objects such as tables, views, stored procedures which are referenced in the operation of the application. The application role will have no knowledge of these objects and will fail to operate correctly.
To install the Visual APS Client
Applies to: LYNQ 2019, Installation, APS, users, deployment, install, client licence, security, permissions, SQL
Functional Area: Integration