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;
