Access rights are not checked for connection objects when executing SQL jobs

Article Id: 84867

Status: Published

Updated On: 15-04-2018 08:01

Legacy Id: 000009190

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
N/A

A user that has the execute permission to SQL jobs is able to execute SQL jobs that use any Connection Object, even if that user does NOT have execute permission on that Connection object.

Stated another way:

If the NOT permission is set on a specific connection object (thereby blocking all access to that specific object), the user will not be able to open or edit the connection object BUT will be able to use it in any SQL job and have that job run successfully.

Cause:

Cause type:
Defect
Root Cause: Design error

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component(s): Initialdata

Fixed Versions:
Automation.Engine 12.0.0 - already available
Automation Engine 11.2.1 - Available
Automation Engine 11.1.3 - Available
Automation Engine 10.0.7 - Available

Additional Information:

Workaround :
N/A