API for role assignment to a user

Indirect Responsibility assignment.

In some organizations, role based responsibilities will be given instead of direct responsibility assignment. To assign an indirect responsibility you can use below API.

Begin

Wf_local_synch.PropagateUserRole(

p_user_name => 'XXUSER',

p_role_name =>  <Role>,

p_start_date=>'03-APR-18',

p_expiration_date=>null);

commit;

End;

To get list of active role assignments for a particular role:

select distinct assigning_role from wf_user_role_assignments

 where user_name='XXUSER'

 and end_date is  null;