Create Tables Permission?

levylabpitt / LV-Data

Collection of LabVIEW VIs to read and write lab data.

BSD 3-Clause "New" or "Revised" License

3 stars 1 forks source link

Create Tables Permission? #113

Closed ciozi137 closed 1 month ago

ciozi137 commented 6 months ago

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...

ciozi137 commented 1 month ago

This was fixed in previous release