Previous | Next | Contents | Index | Glossary |
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 |