← Code-Übersicht

0010_code_datei_app_grants.sql

Pfad: migrations/0010_code_datei_app_grants.sql

Ext: sql

Größe: 758 Bytes

Geändert: 2026-07-16 10:38:31+02

-- Migration 0010: Rechte der App-Rolle demo_app für code_datei + Historie + Audit.
GRANT USAGE ON SCHEMA public TO demo_app;
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.code_datei TO demo_app;
GRANT USAGE, SELECT ON SEQUENCE public.code_datei_id_seq TO demo_app;
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.history_code_datei TO demo_app;
GRANT USAGE, SELECT ON SEQUENCE public.history_code_datei_history_id_seq TO demo_app;
GRANT USAGE ON SCHEMA audit TO demo_app;
GRANT EXECUTE ON FUNCTION audit.fn_write_history() TO demo_app;
GRANT EXECUTE ON FUNCTION audit.fn_touch_updated_at() TO demo_app;
GRANT EXECUTE ON FUNCTION audit.fn_on_create_table() TO demo_app;
GRANT EXECUTE ON FUNCTION audit.enable_versioning(text, text) TO demo_app;