American Tower

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.