Database Access Rights - miwi-hub/myhhb GitHub Wiki

Schema

Schemaname

  • USAGE

Tables

fi_hlp_days

  • SELECT

fi_kontenart

  • SELECT

fi_konto

  • INSERT
  • SELECT
  • UPDATE

fi_mandant

  • SELECT

fi_buchungen

  • INSERT
  • SELECT
  • UPDATE

fi_config_params

  • SELECT
  • UPDATE

fi_quick_config

  • INSERT
  • SELECT
  • UPDATE
  • DELETE

fi_user

  • SELECT

Views

fi_op_summe

  • SELECT

fi_ergebnisrechnungen

  • SELECT

fi_buchungen_view

  • SELECT

fi_v_kontenart

  • SELECT

fi_v_buchungen

  • SELECT

fi_v_konto

  • SELECT

fi_v_config

  • SELECT

Sequences

fi_quick_config_config_id_seq

  • USAGE
  • SELECT
  • UPDATE

fi_buchungen_buchungsnummer_seq

  • USAGE
  • SELECT
  • UPDATE