Differences

This shows you the differences between two versions of the page.

--- database:postgresql [2016/03/24 16:02] – [Commands] tmade
+++ database:postgresql [2017/12/09 01:19] – external edit 127.0.0.1
@@ Line 125: / Line 125: @@
   CREATE DATABASE test OWNER test
+==== Roles and Grants ====
+To add role "CREATEDB" to user test:
-ALTER USER db001 CREATEDB;
-sudo -u postgres psql -c 'alter user db001 with createdb' postgres
+  ALTER USER test CREATEDB;
+or
+  sudo -u postgres psql -c 'alter user test with createdb' postgres