procedure SetAdHocUserStatus (user_name in varchar2, status in varchar2 default 'ACTIVE');
Sets the status of an ad hoc user as 'ACTIVE' or 'INACTIVE'.
Important: If you implement Oracle Directory Services integration, you must maintain your users only through Oracle Directory Services. You must not use the SetAdHocUserStatus() API to update user information in the WF_LOCAL_ROLES table, because you risk discrepancies in your user information and unpredictable results if you use any tool other than Oracle Directory Services to maintain users after integrating with Oracle Directory Services.
| user_name | The internal name of the user. |
| status | A status of 'ACTIVE' or 'INACTIVE' to set for the user. If null, the status is 'ACTIVE'. |