Zmiany pomiędzy wersją 5 and wersją 6 dla AdminGuide/PSQLOWNER

Pokaż
Ignoruj:
Data i czas:
03/10/17 12:58:00 (7 years temu)
Autor:
jpo (IP: 83.144.106.170)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione

  • AdminGuide/PSQLOWNER

    v5 v6  
    2323 
    2424{{{ 
    25 SELECT my_exec1('ALTER SCHEMA ' || aa || ' OWNER TO edokumenty') FROM bs_unnest(array['public', 'syncml_server', 'reports', 'vindication']) aa; 
    26 SELECT my_exec1('GRANT USAGE ON SCHEMA ' || aa || ' TO http') FROM bs_unnest(array['public', 'syncml_server', 'reports', 'vindication']) aa; 
     25SELECT my_exec1('ALTER SCHEMA ' || aa || ' OWNER TO edokumenty') FROM bs_unnest(array['public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica']) aa; 
     26SELECT my_exec1('GRANT USAGE ON SCHEMA ' || aa || ' TO http') FROM bs_unnest(array['public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica']) aa; 
    2727}}} 
    2828 
    2929 
    3030{{{ 
    31 SELECT my_exec1('ALTER TABLE ' || table_schema || '.' || table_name || ' OWNER TO edokumenty') FROM information_schema.views WHERE table_schema IN ('public', 'syncml_server', 'reports', 'vindication'); 
    32 SELECT my_exec1('GRANT SELECT ON ' || table_schema || '.' || table_name || ' TO http') FROM information_schema.views WHERE table_schema IN ('public', 'syncml_server', 'reports', 'vindication'); 
     31SELECT my_exec1('ALTER TABLE ' || table_schema || '.' || table_name || ' OWNER TO edokumenty') FROM information_schema.views WHERE table_schema IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
     32SELECT my_exec1('GRANT SELECT ON ' || table_schema || '.' || table_name || ' TO http') FROM information_schema.views WHERE table_schema IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
    3333}}} 
    3434 
    3535 
    3636{{{ 
    37 select my_exec1('ALTER TABLE ' || schemaname || '.' || tablename || ' OWNER TO edokumenty') from pg_tables where schemaname IN ('public', 'syncml_server', 'reports', 'vindication'); 
    38 select my_exec1('GRANT select, insert, update, delete ON ' || schemaname || '.' || tablename || ' to http') from pg_tables where schemaname IN ('public', 'syncml_server', 'reports', 'vindication'); 
     37select my_exec1('ALTER TABLE ' || schemaname || '.' || tablename || ' OWNER TO edokumenty') from pg_tables where schemaname IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
     38select my_exec1('GRANT select, insert, update, delete ON ' || schemaname || '.' || tablename || ' to http') from pg_tables where schemaname IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
    3939}}} 
    4040 
    4141 
    4242{{{ 
    43 SELECT my_exec1('ALTER TABLE ' || sequence_schema || '.' || sequence_name || ' OWNER TO edokumenty') FROM information_schema.sequences WHERE sequence_schema IN ('public', 'syncml_server', 'reports', 'vindication'); 
    44 SELECT my_exec1('GRANT USAGE ON SEQUENCE ' || sequence_schema || '.' || sequence_name || ' TO http') FROM information_schema.sequences WHERE sequence_schema IN ('public', 'syncml_server', 'reports', 'vindication'); 
     43SELECT my_exec1('ALTER TABLE ' || sequence_schema || '.' || sequence_name || ' OWNER TO edokumenty') FROM information_schema.sequences WHERE sequence_schema IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
     44SELECT my_exec1('GRANT USAGE ON SEQUENCE ' || sequence_schema || '.' || sequence_name || ' TO http') FROM information_schema.sequences WHERE sequence_schema IN ('public', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
    4545}}} 
    4646