My question is about database permissions and rights in Postgres. How can I create reader rights by default when objects are uploaded into PGadmin 4 schemata?
I created the following schema in Postgres called test_schema:
CREATE SCHEMA test_schema AUTHORIZATION jessica_admin; GRANT ALL ON SCHEMA test_schema TO group_members; ALTER DEFAULT PRIVILEGES IN SCHEMA test_schema GRANT SELECT ON TABLES TO group_members CREATE TABLE test_schema.test_table ( ) WITH ( OIDS = FALSE ); ALTER TABLE test_schema.test_table OWNER to jessica_admin; GRANT SELECT ON TABLE test_schema.test_table TO group_members
Now the question is the following: how can I include the following code
ALTER TABLE test_schema.test_table OWNER to jessica_admin; GRANT SELECT ON TABLE test_schema.test_table TO group_members
into the default settings of PgAdmin4? I don't want to do this setting everytime when I add new shapefiles into the scheme, but I want that user (here called group_members) can read the shapefile in PostgreSQL and add this simply into the GIS Interface.