topic Re: Database or user's credentials? in Service

Database or user's credentials?

YoungLearning — Sun, 11 Aug 2024 07:49:34 GMT

Has anyone had a go at this use case, where you can connect to the database with your user credentials?

Re: Database or user's credentials?

Anonymous — Mon, 12 Aug 2024 00:57:34 GMT

Yes. If you have a report thats direct query or composite and you want to respect the row level security inside the database itself. In that case you would pass through the user's credentials for authentication.

If you are using an import dataset, none of that will be relevant.

Re: Database or user's credentials?

Anonymous — Mon, 12 Aug 2024 02:47:51 GMT

Hi YoungLearning

When you connect to a data source or configure a connection for a data source in Service, you use your credentials to connect.
End-user credentials are used for user authentication, while database credentials are used for server authentication.
End-user credentials require greater security because user privacy and data security are involved, and SSO is often the case; Database credentials, on the other hand, are more focused on securing the server.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.