Controlling Access to Data Extract Views

Access to individual views at the access account level can be controlled by granting access via roles. You can create your own company-specific roles so that appropriate choices appear in the list of values in the View Definition window.

Do the following:

1. Create as many database roles as you need; see Creating Custom Database Roles.

2. Add these roles to the DX_ROLES Installation Codelist. All the roles in that reference codelist appear in the list of values in the View Definition window.

3. Grant the database roles to users who need them; see Granting Additional Database Roles to User Accounts.