S6k3vUgT

1CREATE USER api WITH ENCRYPTED PASSWORD 'password';
2
3ALTER DEFAULT PRIVILEGES 
4    FOR USER api
5    IN SCHEMA public
6    GRANT ALL ON ALL TABLES TO api;
7
8
9DROP DATABASE IF EXISTS new_db;
10CREATE DATABASE new_db;
11
12
13CREATE TABLE addresses (
14    address_id INTEGER,
15    address_line_1 VARCHAR(50) NOT NULL,
16    address_line_2 VARCHAR(50),
17    city VARCHAR(50) NOT NULL,
18    state VARCHAR(2) NOT NULL,
19    zipcode VARCHAR(12) NOT NULL,
20    PRIMARY KEY (address_id)
21);
22
23-- Create more tables....
24
25-- Added these in for good measure at the end:
26GRANT all PRIVILEGES on DATABASE new_db to api;
27GRANT ALL ON DATABASE new_db TO api;
28GRANT ALL ON SCHEMA public to api;
29GRANT ALL ON ALL TABLES IN SCHEMA public TO api;
30	
31Name  |  Owner   |   Access privileges   |      Description       
32--------+----------+-----------------------+------------------------
33 public | postgres | postgres=UC/postgres +| standard public schema
34        |          | =UC/postgres         +| 
35        |          | api=UC/postgres       |