From 6cc9d8c72a56563b6d1a12b8b441dfa9dde345e9 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Tue, 28 Apr 2020 17:29:52 +0200
Subject: Long overdue first commit with content

---
 content/en/blog/miscellaneous/postgresql-read-only.md | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 content/en/blog/miscellaneous/postgresql-read-only.md

(limited to 'content/en/blog/miscellaneous/postgresql-read-only.md')

diff --git a/content/en/blog/miscellaneous/postgresql-read-only.md b/content/en/blog/miscellaneous/postgresql-read-only.md
new file mode 100644
index 0000000..c064e97
--- /dev/null
+++ b/content/en/blog/miscellaneous/postgresql-read-only.md
@@ -0,0 +1,17 @@
+---
+title: "Grant postgresql read only access"
+linkTitle: "Grant postgresql read only access"
+date: 2015-11-24
+description: >
+  Grant postgresql read only access
+---
+
+{{< highlight sh >}}
+GRANT CONNECT ON DATABASE "db" TO "user";
+\c db
+GRANT USAGE ON SCHEMA public TO "user";
+GRANT SELECT ON ALL TABLES IN SCHEMA public TO "user";
+ALTER DEFAULT PRIVILEGES IN SCHEMA public
+   GRANT SELECT ON TABLES TO "user";
+{{< /highlight >}}
+
-- 
cgit v1.2.3