/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

7 votes334 views2 answers
3rd height salary sql
SQL
4 votes253 views1 answer
Force drop all tables postgres
SQL
12 votes270 views6 answers
How to install sqlite3 in python
SQL
0 vote245 views1 answer
Like and not like together in sql
SQL
6 votes249 views1 answer
Oracle desc table primary key
SQL
0 vote241 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote258 views1 answer
Sql date d'aujourd'hui
SQL
0 vote245 views1 answer
Minus equivalent in my sql
SQL
2 votes260 views1 answer
SQL IF ELSE
SQL
2 votes269 views1 answer
Sql finding longest and shortest names in a fleld
SQL

Share