Purpose of PUBLIC synonyms in a AutoSys Oracle database

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

When a AutoSys schema is built in Oracle, the 'aedbadmin' user is granted the "CREATE_PUBLIC_SYNONYM" role and there are PUBLIC synonyms created on a select few tables. What is the purpose of granting the role to 'aedbadmin' and the existence of the synonyms?

Resolution

The purpose of granting the "CREATE_PUBLIC_SYNONYM" role to the "aedbadmin" database user is so that it can create public synonyms that are required in the schema. The synonyms are created to facilitate compatibility with legacy 4.5.x agents. The 4.5.x agents connected to the database as "autosys" and the 4.5.x tables were not prefixed with "ujo_" as they are in the current releases. Therefore, the synonyms were required so that queries submitted by the 4.5.x agents would work properly.

Starting 12.0, we will no longer support compatibility with 4.5.x agents. Therefore, the synonyms can be dropped as they will no longer be needed.