/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 vote282 views2 answers
Insert data into multiple tables mysql
SQL
5 votes212 views1 answer
Mysql get last day of month
SQL
0 vote225 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote240 views1 answer
Datatables server side filter where clause
SQL
28 votes243 views4 answers
Delete database mysql
SQL
1 vote234 views1 answer
Date_part mysql
SQL
0 vote252 views1 answer
Insert using condition postgres
SQL
0 vote186 views0 answer
How to connect to datbase in springboot
SQL
1 vote203 views1 answer
Sql myisam vs innodb
SQL
0 vote185 views0 answer
SQL

Share