Differences

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

--- database:postgresql [2016/03/24 16:02] – [Commands] tmade
+++ database:postgresql [2016/03/24 16:03] – [CREATE DB] tmade
@@ 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