We have a linked PostgreSQL server and the remote login and password are parsed using the ODBC settings on the Windows server.
Under the Security tab in Linked Server Properties within SQL, which connection setting should be used please?
- Not be made
- Be made without using a security context
- Be made using the login's current security context
- Be made using this security context
If the last one, why would you want to pass the login credentials twice?