0 Replies Latest reply on Jan 20, 2016 2:33 PM by myCloud

    Add user to an already existing Adhoc Role

    myCloud

      How to add an user to an existing adhoc role from the applications (eBS front-end). I understand we can do it from backend with a below script but wanted to know if this can be done from the applications.

       

      DECLARE
          vRoleName VARCHAR2(100);
          vUserName VARCHAR2(100);
      BEGIN
          vRoleName := 'XXOATESTROLES';
          vUserName := 'NEWNAME';
          wf_directory.AddUsersToAdHocRole(  vRoleName,
                                              vUserName
                                           );
      
          COMMIT;
      END;
      /