/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

11 votes371 views3 answers
Sql line numbers
SQL
0 vote347 views1 answer
Mysql changer nom table
SQL
0 vote364 views1 answer
Full outer join in mariadb mysql
SQL
0 vote371 views1 answer
Delete * from where id = 1;
SQL
0 vote416 views1 answer
Sql query for login with email or username
SQL
0 vote291 views1 answer
Oracle last user logon
SQL
5 votes373 views2 answers
To date oracle
SQL
0 vote462 views1 answer
How to rename a database in tsql
SQL
0 vote355 views1 answer
T sql check active deadlock
SQL
0 vote345 views1 answer
How to combine rows in sql server procedure
SQL