Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Different Data source credentials in each Workspace

I have the same set of reports deployed in 3 different Workspaces; Prod, Test, and Dev.   The datasource is on Azure so there is no Gateway involved.  Once deployed I point the reports to the Prod,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

The DEV report is pointing to the DEV database and the PROD report is pointing to the PROD database., this part works fine as you can see from the lineage. The problem is they both are using the same credentials.  Luckliy I have an admin account that has access to both databases as a workaround, but I want to use the accounts that were created for this purpose.  The dev account has read access to dev, and the prod one has read access to prod.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

So you have 3 databases and one admin account has both access to these databases? Do you have any other account?

 

Best Regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes the admin account has access to all 3 databases.  The 3 accounts setup for reporting on the 3 database only has access to one database each, which I'd expect is good practice and reduces the chances of reports pointing to the wrong environment by mistake.  there are other accounts for other purposes but I'd expect them all to have the same restriction.