Hellen Jiang <hji...@federatedwireless.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
