Zmiany pomiędzy wersją 1 and wersją 2 dla DeployerGuide/OracleFdw

Pokaż
Ignoruj:
Data i czas:
07/29/15 11:41:09 (9 years temu)
Autor:
JP (IP: 85.14.97.6)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione
  • DeployerGuide/OracleFdw

    v1 v2  
    44{{{ 
    55CREATE extension oracle_fdw; 
    6 CREATE SERVER egeria FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '//10.0.0.251/PROD'); 
     6CREATE SERVER egeria FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '//10.0.0.10/PROD'); 
    77GRANT USAGE ON FOREIGN SERVER egeria TO http; 
    8 CREATE USER MAPPING FOR postgres SERVER egeria OPTIONS( user 'zre', password '*****'); 
    9 CREATE USER MAPPING FOR http SERVER egeria OPTIONS( user 'zre', password '*****'); 
     8CREATE USER MAPPING FOR postgres SERVER egeria OPTIONS( user 'admin', password '*****'); 
     9CREATE USER MAPPING FOR http SERVER egeria OPTIONS( user 'admin', password '*****'); 
    1010}}} 
    1111