Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

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 RDBMS. You base your views on the tables DBA_USERS, WF_LOCAL_USERS, DBA_ROLES, and WF_LOCAL_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 and any users stored in WF_LOCAL_USERS. For each DBA user, the originating system is called ORACLE, and the originating system ID is the USERNAME column in DBA_USERS. The default notification preference for each DBA user is MAILHTML.

The WF_ROLES view includes all users in the WF_USERS view, all roles defined in the WF_LOCAL_ROLES table, and all roles in DBA_ROLES, where role_name begins with WF. For each DBA role, the originating system is ORACLE and the originating system ID is the ROLE column in DBA_ROLES. The default notification preference for each DBA role is MAILHTML.

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: Setting Up an Oracle Workflow Directory Service

         Previous  Next          Contents  Index  Glossary