How to make it possible for campaign operators to use data via FDA for AWS PostGreSql External Account?

[PLundmark]

I'm trying to exclude records selected from an AWS PostGreSql database from a campaign target in Adobe Campaign Classic.

The workflow selects recipients in AC and selects recipients in AWS then exclude recipients from AWS from recipients in AC. Two parallel Query activities and then an Exclusion activity based on the two queries. 

If I have admin access this works.

But for normal campaign operators the exclusion activity in the workflow fails.

The Error in the workflow log: 

exclusion You do not have access to data in the data source 'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143:ssl'.

I've created a named right for the data source and assigned it to a non-admin for test.

I've tried naming the named right several things without getting it to work:

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143:ssl'

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com:58143'

'adobe:transactions@qa-transactions-ingress.qa.dataplatform.aws.example.com'

'adobe:transactions@example-eun1-qa-transactions-db' (DB identifier)

How do I make this work?

/Peter

[_Manoj_Kumar_ · Accepted solution]

Hello @PLundmark 

What I would do is create a folder and add this external account to that folder and give all permissions (read/write) to the operator group.

Another way is not ideal but you can add this data to a list and then non-admin users can use that list to create campaigns/workflows.

[Sukrity_Wadhwa]

Hi @PLundmark,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know. In case the given solution was helpful, then kindly choose it as the 'Correct Reply'.

Thanks!