Use pipeline approver's authorization when executing subsequent jobs in VB Studio pipelines

In Oracle Visual Builder Studio (VB Studio), all jobs within a pipeline are currently executed using the authorization of the user who initially triggered the pipeline. We would like Oracle to provide the option to execute subsequent jobs using the authorization of the user who approves the pipeline at an approval gate, rather than always relying on the authorization of the original pipeline initiator.

Current Situation

We use VB Studio to manage our CI/CD deployments across four environments (OTAP: Development, Test, Acceptance and Production).

Our developers can initiate deployment pipelines, but they do not have deployment permissions in the Production environment. Production deployments require approval from an authorized person who has the necessary permissions (in our case the end-user tester).