From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Search path |
Date: | 2019-10-24 16:45:44 |
Message-ID: | dbbc7dfc-180e-a65c-8c1c-2b2ec33a338e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Martinez | 2019-10-24 16:55:59 | Recover databases from raw files (only exists the base directory) |
Previous Message | stan | 2019-10-24 16:41:37 | Search path |