provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

Creating readonly role and schemas in PostgreSQL

Open a-dekker opened this issue 8 months ago • 0 comments

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.

a-dekker avatar Nov 06 '23 12:11 a-dekker