-- -- address GRANT SELECT ON address TO PUBLIC GRANT INSERT 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
--
-- address
GRANT SELECT ON address TO PUBLIC;
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 address TO client_side, administrator;
-- client
GRANT SELECT ON client TO PUBLIC;
GRANT SELECT, UPDATE ON client_id_seq TO client_side, administrator;
GRANT INSERT, UPDATE, DELETE ON address 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_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;