How to Restrict User for running ESS Job

How to Restrict User for running ESS Job

In this section, we will see how to restrict ESS job to specific user.

Let us create simple BIP report and ESS job based on BIP report.

Follow steps mentioned in this below blog post to create Simple BIP report and ESS Job.

  1. Creating Simple BIP report in Oracle Cloud ERP
  2. Creating Custom ESS Jobs in Oracle Cloud ERP.

We have created below ESS Job as:

Graphical user interface, application

Description automatically generated

When we create ESS Job definition, a privilege with same name as job definition is automatically created.

In this case, privilege with name XX Test BIP Report ESS Job will be created. To reflect privilege, we need to run below ESS job:

Import User and Role Application Security Data

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Once this job is completed, we can see privilege is created.

Go to Tools—>Security console—>Roles

Graphical user interface, application

Description automatically generated

Now we need to create custom role and need to add this privilege to that role.

Navigation:

Tools—>Security Console—>Roles—>Create Role.

Graphical user interface, application

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Click on Next.

Graphical user interface, text, application, email

Description automatically generated

Click on Add Privilege to Role.

Graphical user interface, text, application, email

Description automatically generated

Click on Next.

Graphical user interface, text, application

Description automatically generated

Click on Next.

Graphical user interface, text

Description automatically generated

Click on Next.

Graphical user interface, text, application

Description automatically generated

Click on Next.

Graphical user interface, text, application

Description automatically generated

Click on Save and Close.

Graphical user interface, text, application, email

Description automatically generated

Custom Role XX Test Custom Role is created.

Now create two user Test_User1 and Test_User2.

Test_User1

Assign XX Test Custom Role to this user

Test_User2

Do not Assign XX Test Custom Role to this user

Graphical user interface, text, application

Description automatically generated

Graphical user interface, text, application

Description automatically generated

Run below program again:

Import User and Role Application Security Data

Graphical user interface, text, application, email

Description automatically generated

Click on Submit.

Now let us login with user Test_User1 with assigned role and go to Scheduled Process.

Graphical user interface, application

Description automatically generated

Here we can see the ESS Job.

Now login with Test_User2 without custom role and go to Scheduled Process.

Graphical user interface, application, Teams

Description automatically generated

Here ESS job is not available in list of values to run.

In this way, we can restrict ESS job to specific user.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top