Re: [GENERAL] Permissions for Web App - Mailing list pgsql-general

On 10/9/2017 10:51 AM, David G. Johnston wrote:

On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org <igal@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