Creating readonly role and schemas in PostgreSQL

[a-dekker]

We would like to create a read-only role, is there any way to do this? We can create a read-write user by granting create (which results in a grant create on database dbname to user "user-readwrite"), but granting select is not possible in this context, I think we need schema/table grants for that.

Furthermore we would like to create and use schemas, but I see no clue if (is yes, how) this could be applied.

[Bastichou]

Hi,

Late reply but still, schema resource management for postgresql is not managed yet. cf. https://github.com/crossplane-contrib/provider-sql/issues/145

I just forked and started a new branch to support schemas, no ETA but work in progress