Allow different database credentials per dataset or workspace

I just learned through support that all datasets that connect to the same Azure SQL data source are required to use the same SQL credentials.  This is true even if the datasets are published to different workspaces.  I think this approach does not align well with most security frameworks, which typically recommend that each individual consumer have unique credentials.  A better solution would be to allow each dataset to have it's own credentials.  Or alternatively, perhaps credentials would at least be unique per workspace.