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.
