Permission Read Only User

From: Sathish Kumar <satcse88(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Permission Read Only User
Date: 2019-03-15 23:37:52
Message-ID: CANa_DOhWNhL91ew2Rv0ujmGUkAvR5YFwBi-H1nrYsSZuEpSFZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have created a read only user to perform select statements on our
database but whenever we create new tables on the database this user is
unable to view it unless I grant select again for this table. Is there a
way I can make select as default permission for this user so that in future
if I create any new tables, it will be still accessible.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-15 23:42:25 Re: Conditional INSERT
Previous Message Morris de Oryx 2019-03-15 23:30:39 Re: Camel case identifiers and folding