Hellen Jiang <hjiang(at)federatedwireless(dot)com> writes:
> I have created readonly and readwrite roles with the following grants: however, readonly user does not have access to the new tables created by readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can grant the access to readonly to make sure it has the read access to NEW tables created by readwrite user?
The readwrite user (not the admin) would need to issue ALTER DEFAULT
PRIVILEGES granting that.
regards, tom lane