/SQL/Create and attach user to a postgresql database

Create and attach user to a postgresql database

How do I add a user to a postgres database? cli

GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

Source: medium.com

How do I add a user to a postgres database? cli

psql=# grant all privileges on database <dbname> to <username>

Source: medium.com

Create and attach user to a postgresql database

sudo -u postgres psqlpostgres=# create database mydb;postgres=# create user myuser with encrypted password 'mypass';postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Similar codes

0 vote123 views1 answer
Import excel to sql
SQL
2 votes111 views1 answer
Oracle number to percentage
SQL
0 vote115 views1 answer
Data structures in sql
SQL
3 votes142 views2 answers
Oracle sql first day of month
SQL
0 vote116 views1 answer
Alter precision
SQL
0 vote127 views1 answer
How to get nth number in sql
SQL
0 vote124 views1 answer
How to find total working hour in sql
SQL
2 votes110 views1 answer
SELECT INTO
SQL
0 vote114 views1 answer
Sql constarint
SQL
0 vote122 views1 answer
What is between keyword used for
SQL