Is there a way to prompt user to enter their own database credential when common datasource is used?

[Mathumathy]

Whenever I create a data source under a gateway, I provide my credentials of the underlying database. I create workbooks using this data source in the shared workspace and shared the data source with the team members in my organization. The same database credentials that I used for creating the workbook is used by other members while viewing a workbook in the shared space, and it is not prompting for entering the credentials of the viewing user every time.

When the common data source is used by multiple users, is there any possible way to prompt the user to enter their own data source credentials every time?