Assign Oracle Privileges

Each Module Integrator requires specific Oracle privileges to run the Oracle web services they use. If privileges are missing, users cannot use the Integrator(s). This step must be done by someone with access to the Security Console.

If you want to see what access your user already has, they can use the Verify User functionality in the More4apps Toolbox Add-in in Excel locat3ed under the Help option. It will outline what access the user is missing to use the products.

If you have used the Job Role Import in the Admin Utility, you can assign the imported job roles to users. The required privileges are included automatically.

Before assigning anything, you can review the Privileges and what is included in the More4apps Job Roles below:

Assigning More4apps Job Roles

After you have used the Admin Utility Tool to import the predefined Job Roles, you can now assign them to your users.

  1. Log in to your Oracle ERP Cloud instance with Security Console access.

  2. Navigate to Tools > Security Console from your Oracle Homepage.

  3. Using the search box search for the More4apps Job Role.

    1. You can find the Job Role name in the Module guide 'Getting Started' > 'Integrator Privileges' section.

  4. Click the drop down arrow and click 'Edit Role'

    EditRoleDropDown

  5. Go to the Users Tab.

  6. Click 'Add User' and search/add all users for the role

    AddUserButtons

  7. Click 'Next' then Save and Close.

Privilege assignment within Oracle Cloud may not take immediate effect in the environment. Oracle recommends waiting four minutes or more before privileges assignment takes effect. Please refer to the Oracle documentation for further details.

Users can now proceed to Excel and start using the Module. For information on login in see the Login section.

Creating and Assigning Your Own Custom Job Roles

If you do not want to import the More4apps predefined Job Roles you can create your own and populate them yourself.

  1. Log in to your Oracle ERP Cloud instance with Security Console access.

  2. Navigate to Tools > Security Console from your Oracle Homepage.

  3. Click Create Role.

  4. Enter a Role Name, Role Code of your choice, and select 'Common Job Role' as the Role Category

  5. Click Next.

    image21

  6. Under the 'Function Security Policies' page click the 'Add Function Security Policy' button.

  7. Search for and add the additional privileges appropriate for the role you are creating. Repeat this step for all privileges that are required.

    image22

  8. Click 'Next' until you reach the 'Users' Tab.

  9. Click 'Add User' and search/add all users for this role

    image23

  10. Click 'Next' then Save and Close.

image19
Privilege assignment within Oracle Cloud may not take immediate effect in the environment. Oracle recommends waiting four minutes or more before privileges assignment takes effect. Please refer to the Oracle documentation for further details.

Users can now proceed to Excel and start using the Module. For information on login in see the Login section.