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,