Selman ALPDÜNDAR

How to create user and grant permission to user in PostgreSQL

For create database use below in your terminal.

CREATE DATABASE test2; 

Not: do not forget semicolon  if you do not put semicolon your code will not work.

For create user name and password use below in your terminal.

CREATE USER test2 WITH PASSWORD '123456';

Not: do not forget semicolon  if you do not put semicolon your code will not work.

For grant permission to user use below in your terminal.

GRANT ALL ON DATABASE test2 TO test2;

Continue with reading