Обсуждение: Search path

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.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin

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@aklaver.com

stan schrieb am 24.10.2019 um 18:41:
> 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.

As Adrian already pointed out, yes this will work for any connection including one from MS Access.

Note that you can also set this on a per user level, if you don't want all users having the same setting.

   ALTER USER ms_access_user SET search_path = ica , "$user", public;