ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 84867

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

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
Powered by Wolken Software