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

Document ID : KB000084867
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
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