/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 vote129 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
3 votes114 views1 answer
Oracle apex warn on unsaved changes
SQL
2 votes124 views1 answer
Removing view
SQL
23 votes115 views4 answers
How to uninstall postgresql in ubuntu
SQL
57 votes268 views6 answers
Mysql alter table add column
SQL
0 vote116 views1 answer
Postgres - Login and connect as default user
SQL
0 vote118 views1 answer
Query builder doctrien return sql
SQL
20 votes104 views1 answer
Get all table name in sql through php
SQL
1 vote114 views1 answer
Mysql list bigger table
SQL
0 vote98 views1 answer
Carbon mysql d m y to y-m-d
SQL