From 06ecdf2af182034496e2123852deee4a58de1043 Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Sun, 17 Oct 2021 02:52:05 +0200
Subject: making a shoebox

---
 README.md | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 README.md

(limited to 'README.md')

diff --git a/README.md b/README.md
new file mode 100644
index 0000000..fcf2a8f
--- /dev/null
+++ b/README.md
@@ -0,0 +1,37 @@
+# shoebox
+
+A box for shoes :)
+
+## Setup
+
+### Postgres
+
+```bash
+createdb postgres_db
+createuser --interactive postgres_user
+psql postgres_db
+```
+
+```sql
+CREATE ROLE shoebox_group;
+
+REVOKE ALL ON DATABASE shoebox_db FROM public;
+GRANT CONNECT ON DATABASE shoebox_db TO shoebox_group;
+
+GRANT USAGE ON SCHEMA public TO shoebox_group;
+
+GRANT ALL ON ALL TABLES IN SCHEMA public TO shoebox_group;
+GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO shoebox_group;
+
+ALTER DEFAULT PRIVILEGES FOR ROLE shoebox_user IN SCHEMA public
+  GRANT ALL ON TABLES TO shoebox_group;
+
+ALTER DEFAULT PRIVILEGES FOR ROLE shoebox_user IN SCHEMA public
+  GRANT ALL ON SEQUENCES TO shoebox_group;
+
+GRANT shoebox_group TO shoebox_user;
+```
+
+```bash
+knex migrate:latest
+```
-- 
cgit v1.2.3-70-g09d2