-- pristupove prava pre billing

-- CREATE USER billing; -- jak sa toto robi v postgres?

GRANT SELECT ON acl TO billing;
GRANT SELECT ON acl_high TO billing;
GRANT SELECT ON acl_role TO billing;
GRANT SELECT ON acl_role_person TO billing;
GRANT SELECT ON contract TO billing;
GRANT SELECT ON contract_item TO billing;
GRANT SELECT ON contract_item_binding TO billing;
GRANT SELECT ON contract_status TO billing;
GRANT SELECT ON contract_type TO billing;
GRANT SELECT ON contract_type_person TO billing;
GRANT SELECT ON country TO billing;
GRANT SELECT ON entitled_person TO billing;
GRANT SELECT ON entitled_person_type TO billing;
GRANT SELECT ON nationality TO billing;
GRANT SELECT ON person TO billing;
GRANT SELECT ON person_contact TO billing;
GRANT SELECT ON person_contact_status TO billing;
GRANT SELECT ON person_contact_type TO billing;
GRANT SELECT ON person_representation TO billing;
GRANT SELECT ON person_role TO billing;
GRANT SELECT ON sk_kraj TO billing;
GRANT SELECT ON sk_obec TO billing;
GRANT SELECT ON sk_okres TO billing;
GRANT SELECT ON sk_ulica TO billing;
GRANT SELECT ON tarif TO billing;
GRANT SELECT ON tarifaccess TO billing;
GRANT SELECT ON tarifitem TO billing;
GRANT SELECT ON tarifitemgroup TO billing;
GRANT SELECT ON tarifitempack TO billing;
GRANT SELECT ON tarifitemrate TO billing;
GRANT SELECT ON tarifitemunit TO billing;

GRANT SELECT, INSERT, UPDATE ON billitem TO billing;
GRANT USAGE ON billitem_id_seq TO billing;
