YeTQ5HBJ

1DO
2$$
3BEGIN
4  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'driver_gateway_app')
5  THEN
6    CREATE USER driver_gateway_app WITH PASSWORD 'driver_gateway_app_password';
7  END IF;
8END
9$$;
10
11GRANT USAGE ON SCHEMA common TO driver_gateway_app;
12GRANT SELECT ON common.api_token TO driver_gateway_app;
13GRANT UPDATE ON common.api_token TO driver_gateway_app;
14
15DO
16$$
17BEGIN
18  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'manager_gateway_app')
19  THEN
20    CREATE USER manager_gateway_app WITH PASSWORD 'manager_gateway_app_password';
21  END IF;
22END
23$$;
24
25GRANT USAGE ON SCHEMA common TO manager_gateway_app;
26GRANT ALL ON common.api_token TO manager_gateway_app;
27GRANT ALL ON SEQUENCE common.api_token_id_seq TO manager_gateway_app;
28
29DO
30$$
31BEGIN
32  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'customer_gateway_app')
33  THEN
34    CREATE USER customer_gateway_app WITH PASSWORD 'customer_gateway_app_password';
35  END IF;
36END
37$$;
38
39GRANT USAGE ON SCHEMA common TO customer_gateway_app;
40GRANT ALL ON common.api_token TO customer_gateway_app;
41GRANT ALL ON SEQUENCE common.api_token_id_seq TO customer_gateway_app;
42
43DO
44$$
45BEGIN
46  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'customer_app')
47  THEN
48    CREATE USER customer_app WITH PASSWORD 'customer_app_password';
49  END IF;
50END
51$$;
52
53GRANT USAGE ON SCHEMA common TO customer_app;
54GRANT ALL ON common.api_token TO customer_app;
55GRANT ALL ON SEQUENCE common.api_token_id_seq TO customer_app;
56
57DO
58$$
59BEGIN
60  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'core_app')
61  THEN
62    CREATE USER core_app WITH PASSWORD 'core_app_password';
63  END IF;
64END
65$$;
66
67GRANT USAGE ON schema common TO core_app;
68GRANT ALL ON TABLE common.api_token TO core_app;
69GRANT ALL ON SEQUENCE common.api_token_id_seq TO core_app;
70
71DO
72$$
73BEGIN
74  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'manager_app')
75  THEN
76    CREATE USER manager_app WITH PASSWORD 'manager_app_password';
77  END IF;
78END
79$$;
80
81GRANT USAGE ON schema common TO manager_app;
82GRANT ALL ON TABLE common.api_token TO manager_app;
83GRANT ALL ON SEQUENCE common.api_token_id_seq TO manager_app;
84
85DO
86$$
87BEGIN
88  IF NOT EXISTS (SELECT * FROM pg_catalog.pg_user WHERE usename = 'public_api_app')
89  THEN
90    CREATE USER public_api_app WITH PASSWORD 'public_api_password';
91  END IF;
92END
93$$;
94
95GRANT USAGE ON schema common TO public_api_app;
96GRANT ALL ON TABLE common.api_token TO public_api_app;
97GRANT ALL ON SEQUENCE common.api_token_id_seq TO public_api_app;