/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

5 votes217 views1 answer
Oracle nls parameters
SQL
5 votes229 views4 answers
Upload database mysql command line
SQL
0 vote232 views1 answer
Postgres regex word boundary
SQL
0 vote254 views1 answer
How to compile a function in oracle
SQL
0 vote536 views1 answer
Sql field equals multiple values
SQL
0 vote207 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote216 views1 answer
Drop table if exists oracle
SQL
0 vote223 views1 answer
Set a value by excuting stored procedure
SQL
1 vote243 views1 answer
Mariadb get column names from table
SQL
0 vote214 views1 answer
Safe mysql
SQL