• Vytvorit na DB serveri rolu pre noveho zakaznika (cez phpPgAdmin napr)
• Nastavit “default” prava (teda prava ktore dostanu DB objekty, ktore vzniknu v buducnosti. Je potrebne zamenit user za vhodneho uzivatela, kedze dopravca ma osobitny account do samostatnej instancie:

ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON TABLES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON SEQUENCES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON FUNCTIONS FROM PUBLIC;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO transdata;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO transdata;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT EXECUTE ON FUNCTIONS TO transdata;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO stalker;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON SEQUENCES TO stalker;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT EXECUTE ON FUNCTIONS TO user;

-- Niekedy sa stavalo ze nenastavilo po vytvoreni prava nad tabulkami. Tento prikaz ich nastavi spravne:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user;

-- Pri vytvarani sa stavalo ze nenastavilo prava na sekvencie. Tento prikaz ich nastavi spravne:
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to user;

Tento sql skript ulozit aj na server (zamenit v ceste “zakaznik” za nazov zakaznika)

/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/company_specific_scripts/zakaznik/privileges.sql

• Import databazy z dumpu:

/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/dump databazy

Treba davat pozor na to, ze sa v dumpe nachadza aktualna verzia DBS. Ta je ulozena v tabulke versions. Najlepsie je vzdy overit voci niektorej ostrej uz nainstalovanej verzii.

• vytvorit a spustit skript, ktory do databazy vlozi nastavenia specificke pre zakaznika (zamenit v ceste “zakaznik” za nazov zakaznika)

/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/company_specific_scripts/zakaznik/app_settings.sql