From 7bc0e8857351889c4d7a36005679dfc1c4dbbaa8 Mon Sep 17 00:00:00 2001 From: "user@node5.net" Date: Sat, 19 Jul 2025 16:03:54 +0200 Subject: Revert "Cheat sheets/Postgresql - Create database, user and grant permissions" This reverts commit 60cbf43bccd283c1d84ad47dc5433a0747d3583a. --- Cheat sheets/Postgresql.md | 24 ------------------------ 1 file changed, 24 deletions(-) delete mode 100644 Cheat sheets/Postgresql.md diff --git a/Cheat sheets/Postgresql.md b/Cheat sheets/Postgresql.md deleted file mode 100644 index 084ad71..0000000 --- a/Cheat sheets/Postgresql.md +++ /dev/null @@ -1,24 +0,0 @@ ---- -description: Create database, user and grant permissions -created: 2023-12-21 ---- - -## Create database, and user for login - -```bash -sudo -u postgres psql -``` - -```sql -CREATE DATABASE "database_name"; -CREATE ROLE "username"; -ALTER ROLE "username" WITH LOGIN; -ALTER USER "username" WITH PASSWORD 'change_me'; -GRANT SELECT ON "table_name" TO "username"; -``` - -> Replace `database_name`, `username`, `change_me` and `talbe_name` - -## DB backup / restore - - -- cgit 1.4.1