Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:oracle_external_table_execute_script [2018/03/21 22:13] – [Sicherheitsüberlegung] gpipperr
+++ dba:oracle_external_table_execute_script [2023/06/01 09:16] (aktuell) – [Umsetzung] gpipperr
@@ Zeile 55: / Zeile 55: @@
 create directory DB_COMMAND as '/srv/elt/db_command/';
-grant read,write,execute on DB_COMMAND  to DWH_ADMIN;
+grant read,write,execute on directory  DB_COMMAND  to DWH_ADMIN;
 </code>
@@ Zeile 214: / Zeile 214: @@
      DEFAULT DIRECTORY DWH_OP_COMMAND
      ACCESS PARAMETERS
-     ( 	PREPROCESSOR DWH_OP_COMMAND:'readCrontab.sh'
+     (
         RECORDS DELIMITED BY NEWLINE
+        PREPROCESSOR DWH_OP_COMMAND:'readCrontab.sh'
         LOGFILE  'DWH_OP_COMMAND':'readCronTab.log'
         BADFILE 'DWH_OP_COMMAND':'readCronTab.bad'