Actions
Tareas #79
open
Permisos de usuario a noc_writer
Status:
Resuelta
Priority:
Normal
Assignee:
-
Start date:
07/01/2026
Due date:
07/01/2026 (29 days late)
% Done:
100%
Estimated time:
Description
El usuario noc_writer asignado al equipo del NOC para que desarrollen su herramienta de seguimiento compartido de incidentes no tenía permisos de acceso sobre las tablas.
Updated by Demo MiGestion365 Admin 29 days ago
- Due date set to 07/01/2026
- Status changed from Nueva to Resuelta
- % Done changed from 0 to 100
Se le asignan los permisos correspondientes sobre el ambiente Dev de postgres
GRANT SELECT ON ALL TABLES IN SCHEMA noc_utility TO noc_writer;
GRANT INSERT, UPDATE, DELETE ON ALL TABLES IN schema noc_utility TO noc_writer;
DO $$
DECLARE
r RECORD;
BEGIN
FOR r IN SELECT schema_name
FROM information_schema.schemata
WHERE schema_name NOT IN ('pg_catalog', 'information_schema')
LOOP
EXECUTE format('GRANT USAGE ON SCHEMA %I TO noc_writer;', r.schema_name);
EXECUTE format('GRANT SELECT ON ALL TABLES IN SCHEMA %I TO noc_writer;', r.schema_name);
END LOOP;
END$$;
Actions