Greetings, * Igal @ Lucee.org (igal@xxxxxxxxx) wrote: > It worked, thanks! Be sure to check that you're really getting what you want here. > For future reference and for the benefit of others, the command that > I ran is: > > ALTER DEFAULT PRIVILEGES IN SCHEMA public > GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO webapp; Note that DEFAULT PRIVILEGES apply to a specific role (in the above case, whatever CURRENT_USER is) and therefore will only be helpful if you only have one user creating tables, in this case. There's been a lot of questions and discussions about having an actual 'read only' role that can be granted out. Now that we've actually got default roles in PG, this is something that becomes at least somewhat more practical and might be able to happen for PG11 if there's interest and effort put into it. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
