From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Search path |
Date: | 2019-10-25 06:13:03 |
Message-ID: | b8356568-a205-82dc-fd38-d617b31533ca@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | rihad | 2019-10-25 08:22:58 | Quere keep using temporary files |
Previous Message | Sonam Sharma | 2019-10-25 05:34:47 | Index |