diag_fdw.sql
569 Bytes
-- Diagnóstico de Integridad FDW Entidad 505
SELECT '--- TABLAS IMPORTADAS EN fdw_505 ---' as reporte;
SELECT table_name FROM information_schema.tables WHERE table_schema = 'fdw_505' ORDER BY table_name;
SELECT '--- COLUMNAS DE fdw_505.usuarios ---' as reporte;
SELECT column_name, data_type FROM information_schema.columns
WHERE table_schema = 'fdw_505' AND table_name = 'usuarios'
ORDER BY ordinal_position;
SELECT '--- PRUEBA DE ACCESO (SIN DESENCRIPTAR) ---' as reporte;
SELECT usu_alias, ejer_fisca FROM fdw_505.usuarios WHERE usu_alias = 'operador' LIMIT 1;