Previous  Next          Contents  Index  Glossary  Library

Integrating Oracle Workflow Directory Services with Native Oracle Users

If you plan to use the standalone version of Oracle Workflow, you can map your directory service to the native users and roles in the Oracle RDMBS. You base your views on the tables DBA_USERS and DBA_ROLES.

Oracle Workflow provides a script you can use to setup the views. Use the wfdirouv.sql script in the Oracle Workflow sql subdirectory on your server. This script creates three views.

The WF_USERS view creates a workflow user for each DBA user. The originating system is called ORACLE, and the USERNAME column in DBA_USERS is the originating system ID. The default notification preference is MAILHTML.

The WF_ROLES view includes all users in the WF_USERS view and all roles defined in the DBA_ROLES table as workflow roles. The originating system is ORACLE and the originating system ID is the ROLE column in DBA_ROLES.

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