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 <http://lucee.org/>