On 5/12/22 22:13, Bryn Llewellyn wrote:
>> /neerajmr12219@gmail.com <mailto:neerajmr12219@gmail.com> wrote:/
>>
> What exactly do you mean by "have created a new user and granted
> connection access to database"? As I understand it, there's no such
> thing. I mentioned a simple test in my earlier email that showed that
> any user (with no schema of its own and no granted privileges) can
> connect to any database—and see the full metadata account of all its
> content. I'm teaching myself to live with this.
Besides the REVOKE CONNECT, it is also possible to prevent connections
to a given database by a particular user by using settings in pg_hba.conf.
--
Adrian Klaver
adrian.klaver@aklaver.com