American Tower

Se le otorgan permisos generales por posibles inconvenientes post upgrade de postgres

DO $$
DECLARE
schema_name text;
BEGIN
FOR schema_name IN
SELECT s.schema_name
FROM information_schema.schemata s
WHERE s.schema_name NOT IN ('pg_catalog', 'information_schema')
LOOP
EXECUTE format('GRANT ALL PRIVILEGES ON SCHEMA %I TO postgres;', schema_name);
EXECUTE format('GRANT USAGE ON SCHEMA %I TO om_read;', schema_name);
EXECUTE format('GRANT SELECT ON ALL TABLES IN SCHEMA %I TO om_read;', schema_name);
EXECUTE format('GRANT USAGE ON SCHEMA %I TO jibanez;', schema_name);
EXECUTE format('GRANT SELECT ON ALL TABLES IN SCHEMA %I TO jibanez;', schema_name);
END LOOP;
END $$;