/SQL/Postgres set user as superuser

Postgres set user as superuser

Postgres set user as superuser

ALTER USER myuser WITH SUPERUSER;

1

Source: stackoverflow.com

Postgres create user with superuser privileges

sudo -u postgres createuser -s -i -d -r -l -w <<username>>
sudo -u postgres psql -c "ALTER ROLE <<username>> WITH PASSWORD '<<password>>';"

1

Source: stackoverflow.com

Similar codes

0 vote370 views1 answer
Edit a field mysql terminal
SQL
0 vote357 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
7 votes435 views2 answers
3rd height salary sql
SQL
0 vote374 views1 answer
Longtext sql
SQL
0 vote356 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote394 views1 answer
Primary key start from number
SQL
1 vote361 views2 answers
Mysql allow remote connections
SQL
5 votes383 views4 answers
Start postgres server
SQL
1 vote364 views3 answers
Getdate function in postgresql
SQL
0 vote304 views1 answer
Sql count how many times a value appears
SQL

Share