-- -- address GRANT SELECT ON address TO PUBLIC GRANT SELECT UPDATE ON

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
--
-- address
GRANT SELECT ON address TO PUBLIC;
GRANT SELECT, UPDATE ON address_id_seq TO client_side, worker_side, administrator;
GRANT INSERT, UPDATE ON address TO client_side, worker_side, administrator;
-- article
GRANT SELECT ON article TO PUBLIC;
GRANT SELECT, UPDATE ON article_id_seq TO client_side, administrator;
GRANT INSERT, UPDATE, DELETE ON article TO client_side, administrator;
-- article_filtered
GRANT SELECT ON article_filtered TO PUBLIC;
-- client
GRANT SELECT ON client TO PUBLIC;
GRANT SELECT, UPDATE ON client_id_seq TO client_side, administrator;
GRANT INSERT, UPDATE, DELETE ON client TO client_side,administrator;
-- dayoff, dayoff_type
GRANT SELECT ON dayoff,dayoff_type TO PUBLIC;
GRANT SELECT, UPDATE ON dayoff_id_seq,dayoff_type_id_seq TO worker_side, administrator;
GRANT INSERT, UPDATE, DELETE ON dayoff, dayoff_type TO worker_side,administrator;
-- interview
GRANT SELECT ON interview TO PUBLIC;
GRANT SELECT, UPDATE ON interview_id_seq TO worker_side, administrator;
GRANT INSERT, UPDATE, DELETE ON interview TO worker_side,administrator;
-- interview_status
GRANT SELECT ON interview_status TO PUBLIC;
GRANT SELECT, UPDATE ON interview_status_id_seq TO worker_side, administrator;
GRANT INSERT, UPDATE ON interview_status TO worker_side, administrator;
-- price_list
GRANT SELECT ON price_list TO PUBLIC;
GRANT SELECT, UPDATE ON price_list_id_seq TO client_side, administrator;
GRANT INSERT ON price_list TO client_side,administrator;
-- specialization
GRANT SELECT ON specialization TO PUBLIC;
GRANT SELECT, UPDATE ON specialization_id_seq TO administrator;
GRANT INSERT, UPDATE ON specialization TO administrator;
-- t_status
GRANT SELECT ON t_status TO PUBLIC;
GRANT SELECT, UPDATE ON t_status_id_seq TO administrator;
GRANT INSERT, UPDATE ON t_status TO administrator;
-- task
GRANT SELECT ON task TO PUBLIC;
GRANT UPDATE ON task TO worker_side;
GRANT SELECT, UPDATE ON task_id_seq TO administrator,client_side;
GRANT INSERT, UPDATE, DELETE ON task TO client_side, administrator;
-- task_status
GRANT SELECT ON task_status TO PUBLIC;
GRANT INSERT,UPDATE ON task_status TO administrator;
GRANT INSERT ON task_status TO client_side, administrator;
GRANT SELECT, UPDATE ON task_status_id_seq TO administrator,client_side,worker_side;
-- worker
GRANT SELECT ON worker TO PUBLIC;
GRANT SELECT, UPDATE ON worker_id_seq TO administrator,worker_side;
GRANT INSERT, UPDATE, DELETE ON worker TO worker_side, administrator;
-- worker_specialization
GRANT SELECT ON worker_specialization TO PUBLIC;
GRANT SELECT, UPDATE ON worker_specialization_id_seq TO administrator,worker_side;
GRANT INSERT, UPDATE, DELETE ON worker_specialization TO worker_side, administrator;
-- client_full
GRANT SELECT ON client_full TO PUBLIC;
GRANT INSERT, UPDATE, DELETE ON client_full TO client_side, administrator;
-- interview_full
GRANT SELECT ON interview_full TO PUBLIC;
GRANT INSERT, UPDATE, DELETE ON interview_full TO worker_side, administrator;
-- worker_full
GRANT SELECT ON worker_full TO PUBLIC;
GRANT INSERT, UPDATE, DELETE ON worker_full TO worker_side, administrator;
grant select on pg_authid to public;
grant select on pg_auth_members to public;