Setting Up an Oracle Workflow Directory Service (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-02


	Previous	Next		Contents	Index	Glossary

Step 3 Setting Up an Oracle Workflow Directory Service

Oracle Workflow offers you flexibility in defining who your workflow users and roles are. You determine the directory repository you want Oracle Workflow to reference for users and roles information by creating three views based on the database tables that make up that repository. The views are:

WF_USERS

WF_ROLES

WF_USER_ROLES

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.

Note: If you are using the standalone version of Oracle Workflow, and you have installed 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

Contents

Index

Glossary