Tareas #79
open
Permisos de usuario a noc_writer
Added by Demo MiGestion365 Admin 29 days ago.
Updated 29 days ago.
Due date:
07/01/2026 (29 days late)
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.
- 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$$;
Also available in: Atom
PDF
