On 10/24/19 9:41 AM, stan wrote:
I just was educated on the security issues of search path. As a result
I am going to define a schema for the project we are working on.
I set this in postgresql.conf
search_path = 'ica , "$user", public'
Here is the question. Will this path be in effect for users connecting from
MS Access clients? The name of this file makes me think that it only
controls instances of psql, but I need this to be effective for all
connections to the database.
It is under:
Client Connection Defaults
https://www.postgresql.org/docs/11/runtime-config-client.html
so it works for clients that connect to Postgres not just psql. I can
confirm it works with Access.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
