Re: Read only user permission

On 8/23/23 13:23, Hellen Jiang wrote:
>
> Sorry it is a typo in the email. My readonly role is dbreadonly. It
> works well so far except no access to new tables created by read write
> role. It has access to new tables created by admin role.
>
> I granted dbreadonly as the following:
>
> -- Read-only role
> GRANT CONNECT ON DATABASE mydatabase TO dbreadonly;
> GRANT USAGE ON SCHEMA public TO dbreadonly;
> GRANT SELECT ON ALL TABLES IN SCHEMA public TO dbreadonly;
> GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO dbreadonly;
> ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO
> dbreadonly;
>

Is "public" a good schema to use for this sort of thing, or does it matter?