| 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