ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

GRANT "DDL_ADMIN" TO "ETL_RO"; -- Das ist eine SUVA spezifische Rolle zum Anlegen eigener Objekte
GRANT "R_ETL_RO" TO "ETL_RO";
ALTER USER "ETL_RO" DEFAULT ROLE ALL;

GRANT LOGMINING TO "ETL_RO";
GRANT SELECT ANY DICTIONARY TO "ETL_RO";
GRANT LOCK ANY TABLE TO "ETL_RO";
GRANT ALTER SESSION TO "ETL_RO";
GRANT CREATE SESSION TO "ETL_RO";

GRANT SELECT ON "SYS"."V_$DATABASE" TO "ETL_RO";
GRANT SELECT ON "SYS"."V_$ARCHIVED_LOG" TO "ETL_RO";
GRANT SELECT ON "SYS"."V_$LOGMNR_CONTENTS" TO "ETL_RO";
GRANT EXECUTE ON "SYS"."DBMS_LOGMNR" TO "ETL_RO";
GRANT EXECUTE ON "SYS"."DBMS_LOGMNR_D" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MOMS_SPLIT_DOC" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MXCSDOCFOLDERS" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MXCSDOCUMENTPROPERTIES" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MXCSDOCUMENT" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MOMS_INPUT_DOC" TO "ETL_RO";
GRANT FLASHBACK ON "MTEXT"."MOMS_STACKRUN" TO "ETL_RO";