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.
