Es que exactamente eso es lo que les consulto. Al ser ustedes los “dueños del producto” quizás podían facilitar todas las sentencias de permisos.
En base a esto, creé el usuario “diaguita” y fui agregando los permisos conforme saltaron lo errores.
GRANT ALL PRIVILEGES ON DATABASE diaguita TO diaguita;
GRANT ALL ON SCHEMA diaguita TO diaguita;
GRANT ALL ON SCHEMA toba_diaguita_logs TO diaguita;
GRANT ALL ON SCHEMA toba_diaguita TO diaguita;
GRANT ALL ON SCHEMA diaguita_auditoria TO diaguita;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diaguita TO diaguita;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA toba_diaguita_logs TO diaguita;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA toba_diaguita TO diaguita;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diaguita_auditoria TO diaguita;
GRANT ALL ON ALL SEQUENCES IN SCHEMA diaguita TO diaguita;
GRANT ALL ON ALL SEQUENCES IN SCHEMA toba_diaguita TO diaguita;
GRANT ALL ON ALL SEQUENCES IN SCHEMA toba_diaguita_logs TO diaguita;
Espero les sirva.
Saludos!