Permissions for Web App

["Igal @ Lucee.org" <igal@xxxxxxxxx>]

Hello,

I created a role named `webapp` as follows:

  CREATE ROLE webapp WITH LOGIN PASSWORD 'changeme';

While in development, I want to give that role permissions on all tables in schema public.  So far I've been using the following command, which works on existing tables:

  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO webapp;

But I want to give that role permissions on future tables since I add new tables and drop/recreate current ones.

How can I do that?

Thanks,

Igal Sapir
Lucee Core Developer
Lucee.org