procedure SetAdHocRoleExpiration (role_name in varchar2, expiration_date in date default sysdate);
Updates the expiration date for an ad hoc role.
Note that although ad hoc users and roles whose expiration date has passed do not appear in the seeded WF_USERS, WF_ROLES, and WF_USER_ROLES views, they are not removed from the Workflow local tables until you purge them using Directory(). You should periodically purge expired ad hoc users and roles in order to improve performance. See: Directory.
| role_name | The internal name of the ad hoc role. |
| expiration_date | New expiration date. If null, the procedure defaults the expiration date to sysdate. |