postgres grant commands

 

login to postgres:

 

sudo -i -u postgres

 

psql

 

 

CREATE DATABASE sales;
GRANT ALL PRIVILEGES ON DATABASE sales TO bbwvsuxaqmboxlduukof;

\c sales
GRANT ALL PRIVILEGES ON SCHEMA public TO bbwvsuxaqmboxlduukof;
GRANT USAGE ON SCHEMA public TO bbwvsuxaqmboxlduukof;
GRANT CREATE ON SCHEMA public TO bbwvsuxaqmboxlduukof;

Leave a Reply

Your email address will not be published. Required fields are marked *