Обсуждение: 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;