| Previous | Next |  | Contents | Index | Glossary

## WF_USER_ROLES

The `WF_USER_ROLES` view is an intersection of the users and roles in `WF_USERS` and `WF_ROLES`. Create this view, making sure it contains the following columns:

- User_Name--The internal name of the user as listed in the view `WF_USERS`.

- User_Orig_System--A code that you assign to the user directory repository as listed in the view `WF_USERS`.

- User_Orig_System_ID--The primary key that identifies the user in the user directory repository as listed in the view `WF_USERS`.

- Role_Name--The internal name of the role as listed in the view `WF_ROLES`.

- Role_Orig_System--A code that you assign to the role directory repository as listed in the view `WF_ROLES`.

- Role_Orig_System_ID--The primary key that identifies the role in the role directory repository as listed in the view `WF_ROLES`.

> Attention: To take advantage of unique indexes when querying users, make sure you initially enter the usernames in your database in uppercase only. Forcing the usernames to uppercase in your view definition results in poor performance when accessing these views.

> Warning: Avoid making a join to a view that contains a union as this results in poor database performance. Oracle8i is unable to preserve the indexes in that view when you make such a join. The workflow directory services views you create will most likely contain unions, therefore you should not join to them directly. If you need to retrieve data from any of the three directory services views, use the appropriate directory services API. See: Workflow Directory Services APIs.

| Previous | Next |  | Contents | Index | Glossary