Previous	Next		Contents	Index	Glossary

Oracle Workflow provides a script you can use to set up 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 your custom directory repository.

Attention: If you want to implement Oracle Internet Directory (OID) integration for the standalone version of Oracle Workflow, you must run the wfdircsv.sql script to ensure that your directory service views are mapped only to the WF_LOCAL tables, because only the WF_LOCAL_USERS table will be synchronized with OID. (Only users are maintained through OID, not Workflow roles.) In this case, you must not customize the script to incorporate any other tables. After implementing OID integration, you maintain your user information only through OID. See: Synchronizing Workflow Directory Services with Oracle Internet Directory.

The originating system in the WF_USERS view is called WF_LOCAL_USERS, 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_ROLES 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: Setting Up an Oracle Workflow Directory Service

Copyright © 2002 Oracle Corporation.
All Rights Reserved.