Previous | Next | Contents | Index | Glossary |
In addition, Oracle Workflow provides three local tables called WF_LOCAL_USERS, WF_LOCAL_ROLES, and WF_LOCAL_USER_ROLES that contain columns similar to those defined in the WF_USERS, WF_ROLES, and WF_USER_ROLES views, respectively. You can use these tables to store users and roles not included in your existing directory repository by calling the appropriate Directory Service PL/SQL API. See: Workflow Directory Service APIs.
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.
Context: You need to perform this step only once.
See: Predefined Directory Services
Previous | Next | Contents | Index | Glossary |