On 10/9/2017 10:51 AM, David G. Johnston wrote:
On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org <i...@lucee.org
<mailto:i...@lucee.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/>
