levylabpitt/LV-Data

Create Tables Permission?

Opened this issue · 0 comments

ciozi137 commented

New tables are not getting proper permissions. I ran the following:

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO llab_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, insert  ON TABLES TO llab_writer;

This should apply to all new tables going forward. Evaluate after new tables are created...