Create User

create user john createdb;

or

create user john;
alter user john createdb;

create with password

create user bobbins;
alter user bobbins createdb;
alter user bobbins password 'snuffle';

schema privileges

CREATE DATABASE EXAMPLE_DB;
CREATE USER EXAMPLE_USER WITH ENCRYPTED PASSWORD 'Sup3rS3cret';
GRANT ALL PRIVILEGES ON DATABASE EXAMPLE_DB TO EXAMPLE_USER;
\c EXAMPLE_DB postgres
# You are now connected to database "EXAMPLE_DB" as user "postgres".
GRANT ALL ON SCHEMA public TO EXAMPLE_USER;

Grant For Tables

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO userName;