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.klaver@xxxxxxxxxxx
