On 3/15/19 4:37 PM, Sathish Kumar wrote:
> 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.
Maybe this?:
https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com