Project

General

Profile

Actions
Copy link

Tareas #107

open

Grants a tablas cm en postgres

Added by Demo MiGestion365 Admin about 1 month ago. Updated about 1 month ago.

Status:
Resuelta
Priority:
Normal
Assignee:
-
Start date:
08/21/2026
Due date:
08/21/2026 (38 days late)
% Done:

100%

Estimated time:
4:00 h

Description

Debido a que se crearon nuevos usuarios de acceso en postgres y que el loader renueva los grants con cada corrida, se hace necesario garantizar el acceso a estos nuevos usuarios con un script externo que se ocupe sólo de eso.

Actions
Copy link
 #1

Updated by Demo MiGestion365 Admin about 1 month ago

  • Status changed from Nueva to Resuelta
  • % Done changed from 0 to 100

Se genera un script grant_mantenimiento.sh que aporta las credenciales y llama al archivo grants_mant.sql

ingenieria@pgsql-dev:~/loader$ more grant_mantenimiento.sh
#!/bin/bash

PGPASSWORD='post3008' psql
-h 127.0.0.1
-U postgres
-d postgres
-f grants_mant.sql
> grants_mant.log 2>&1
ingenieria@pgsql-dev:~/loader$

-- =====================================================
-- ACCESO AL ESQUEMA CM
-- =====================================================

GRANT USAGE ON SCHEMA cm TO sice_mant;
GRANT USAGE ON SCHEMA cm TO mobisond_mant;
GRANT USAGE ON SCHEMA cm TO splices_mant;
GRANT USAGE ON SCHEMA cm TO fleet_mant;

-- =====================================================
-- PERMISOS DE SOLO LECTURA
-- =====================================================

GRANT SELECT ON TABLE cm.ci_feeder_distribution TO sice_mant;
GRANT SELECT ON TABLE cm.ci_fosc TO sice_mant;
GRANT SELECT ON TABLE cm.ci_headend TO sice_mant;
GRANT SELECT ON TABLE cm.ci_op TO sice_mant;
GRANT SELECT ON TABLE cm.ci_sfat_mfat_bfat TO sice_mant;

GRANT SELECT ON TABLE cm.ci_feeder_distribution TO mobisond_mant;
GRANT SELECT ON TABLE cm.ci_fosc TO mobisond_mant;
GRANT SELECT ON TABLE cm.ci_headend TO mobisond_mant;
GRANT SELECT ON TABLE cm.ci_op TO mobisond_mant;
GRANT SELECT ON TABLE cm.ci_sfat_mfat_bfat TO mobisond_mant;

GRANT SELECT ON TABLE cm.ci_feeder_distribution TO splices_mant;
GRANT SELECT ON TABLE cm.ci_fosc TO splices_mant;
GRANT SELECT ON TABLE cm.ci_headend TO splices_mant;
GRANT SELECT ON TABLE cm.ci_op TO splices_mant;
GRANT SELECT ON TABLE cm.ci_sfat_mfat_bfat TO splices_mant;

GRANT SELECT ON TABLE cm.ci_feeder_distribution TO fleet_mant;
GRANT SELECT ON TABLE cm.ci_fosc TO fleet_mant;
GRANT SELECT ON TABLE cm.ci_headend TO fleet_mant;
GRANT SELECT ON TABLE cm.ci_op TO fleet_mant;
GRANT SELECT ON TABLE cm.ci_sfat_mfat_bfat TO fleet_mant;

Estos ejecutable son llamados dentro del loader.sh para que sean ejecutados al finalizar la recarga y generación de las tablas de cm.

Actions
Copy link

Also available in: Atom PDF