Some more articles reformatting

1 files changed, 7 insertions, 6 deletions

diff --git a/content/blog/miscellaneous/postgresql-read-only.md b/content/blog/miscellaneous/postgresql-read-only.md
index c064e97..0b88d90 100644
--- a/content/blog/miscellaneous/postgresql-read-only.md
+++ b/content/blog/miscellaneous/postgresql-read-only.md
@@ -1,17 +1,18 @@
 ---
 title: "Grant postgresql read only access"
-linkTitle: "Grant postgresql read only access"
 date: 2015-11-24
-description: >
-  Grant postgresql read only access
+description: How to grant read only access to a postgresql user
+tags:
+  - PostgreSQL
 ---
 
+## The solution
+
+Here is the bare minimum a user need in order to have complete read only access on a postgresql database :
 {{< 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";
+ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "user";
 {{< /highlight >}}
-