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:
-
Create as many database roles as you need; see Creating Custom Database Roles.
-
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.
-
Grant the database roles to users who need them; see Granting Additional Database Roles to User Accounts.
Parent topic: Configuring Data Extract