Tareas #97
open
Permisos sobre tabla altiplano.serial (usuario om_read)
100%
Description
Se recibe el reclamo de falta de permisos post actualización de postgres producción
Files
Updated by Demo MiGestion365 Admin about 2 months ago
- Due date set to 08/04/2026
- Status changed from Nueva to Resuelta
- % Done changed from 0 to 100
- Estimated time set to 1:00 h
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 $$;