WF_USER_ROLES (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-03


				Contents	Index	Glossary	Master Index	Feedback

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. The Oracle database server 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