User Specific Credential Question

Hi

We're using an SQL Database as a data source.

Instead of creating 20 accounts on the DB for all of our team, we created 2 account: One for Read/Write permissions and one for ReadOnly permissions.

But we want to use user specific settings for credentials entry.

Users with the RW account in their data source settings are able to enter a different credentials, but those with the RO account are all using the same credentials.

Should we use different SQL account for each users ?