On 10/9/2017 10:51 AM, David G. Johnston wrote:
> On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org <igal(at)lucee(dot)org
> <mailto:igal(at)lucee(dot)org>>wrote:
>
> But I want to give that role permissions on future tables since I
> add new tables and drop/recreate current ones.
>
>
> ALTER DEFAULT PRIVILEGES
>
> https://www.postgresql.org/docs/9.6/static/sql-alterdefaultprivileges.html
It worked, thanks!
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;
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>