|Oracle Workflow Guide
Part Number A95265-03
Attention: You should avoid selecting from DUAL to incorporate additional users and roles into the directory service views as this allows you to violate the unique constraint on certain columns of the views and reduces performance with unnecessary joins between the 'select from DUAL' statements.
Note: If you are using the standalone version of Oracle Workflow, and you have installed Oracle9i Release 2 or higher or Oracle9iAS Release 2 or higher, you can integrate your Workflow directory service with Oracle Internet Directory (OID) as your directory repository. In this case, you must map your directory service views only to the WF_LOCAL tables to enable synchronization of Workflow user information with OID. See: Integrating Oracle Workflow Directory Services with Local Workflow Users and Synchronizing Workflow Directory Services with Oracle Internet Directory.
Context: You need to perform this step only once.
See: Predefined Directory Services
See: Ad Hoc Users and Roles