Script (API ) To add and revoke the User Roles in User Managment

1. Assign role to a user using an API

To assign role to a user using APIs, use the following API wf_local_synch.PropagateUserRole.

Select * from UMX_ALL_ROLE_VL --> Gives List of all available Roles with Role Key.

Example:

Begin
wf_local_synch.PropagateUserRole(
     p_user_name => '&USER_NAME',
     p_role_name => '&ROLE_KEY');
commit;
end;

2. Revoke an Indirect Responsibility

To revoke an indirect responsiblity (roles assigned using UMX) assignment to a user using APIs, use the following API Wf_local_synch.PropagateUserRole.

Example:

Begin
Wf_local_synch.PropagateUserRole(
       p_user_name => '&USER_NAME',
       p_role_name => '&ROLE_KEY',
       p_start_date=>'&Start_Date',
       p_expiration_date=>'&End_Date');
commit;
End;

Steps to get the Access to Integration Administrtor and SOA Monitor In Integration Repository for Integrated SOA Gateqway

1. Log in as a user with User Management Responsibility Like   Sysadmin.
2. Click “User”.
3. Put the User under “User Name” > go.
4. Then click “Update” button (Pencil).
5. Click “Assign Role”.
6. Under “Search By > Roles and Responsibilities” Put the Responsibilities like “System Integration Analyst” and Click “go”.
7. Check mark and click “Select”.
8. Put “Justification” and click “Save”.
9. Keep doing for from Step 5 to 8 for “System Integration Developer” and “Irep Administrator”.
10. Log out from Self Service and Log in as a user who been     assigned 3 roles.
11. Select Integrated SOA Gateway and should have the following    under “Integrated SOA      Gateway” menu.
* Integration Repository
* SOA Monitor
12. The function for Integration Repository and SOA Monitor should be visible.

Integrated SOA Gateway (Integration Repository)