Previous  Next          Contents  Index  Glossary  Library

Integrating Oracle Workflow Directory Services with Local Workflow Users

If you plan to use the standalone version of Oracle Workflow, you can map your directory service to the local workflow users and roles stored in the WF_LOCAL_USERS and WF_LOCAL_ROLES tables.

Oracle Workflow provides a script you can use to setup the views. Use the wfdircsv.sql script in the Oracle Workflow sql subdirectory on your server. This script creates three views. You can customize the views in this script to incorporate the users and roles from you custom directory repository.

The originating system in the WF_USERS view is called WF_LOCAL, and the originating system ID is 0.

The WF_ROLES view includes all users in WF_LOCAL_USERS and all roles defined in WF_LOCAL_ROLES. The originating system is WF_LOCAL and the originating system ID is 0.

The WF_USER_ROLES view consists of the names and originating system information of both users and roles in WF_USERS and WF_ROLES.

See Also

Setting Up an Oracle Workflow Directory Service

         Previous  Next          Contents  Index  Glossary  Library