Each Data Validation Option user is associated with a PowerCenter user. When you run a data validation test, the PowerCenter Integration Service runs the underlying workflow based on the credentials of the associated PowerCenter user. You must configure the user permissions and user privileges on the corresponding PowerCenter Repository Service.
Create a user account for each Data Validation Option user.
Log in to the Administrator tool.
Click the
Security
tab.
In the
Users
area, click the
Actions
button, and then select
Create User
.
Enter the user information and then click
OK
.
If the domain uses Kerberos authentication, enter a user name that matches the Windows login name.
You specify this PowerCenter user when you add the PowerCenter repository for Data Validation Option.
Select the user in the
Users
area.
Click the
Privileges
tab.
Select the PowerCenter Repository Service.
The
Edit Roles and Privileges
dialog box appears.
On the
Roles
tab, expand the folder for the PowerCenter Repository Service.
Enable the PowerCenter Connection Administrator custom role.
Click
OK
.
Click the
Permissions
tab.
The
Permissions
tab shows that no permissions are assigned to the user.
Select the PowerCenter Repository Service.
Click the
Edit Direct Permissions
button.
The
Edit Direct Permissions
dialog box appears.
In the
Access
column, select
Allow
.
Click
OK
.
The
Permissions
tab shows that the user has permission on the PowerCenter Repository Service.