/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

1 vote67 views1 answer
Postgres division by zero
SQL
0 vote103 views1 answer
Print boolean in plsql
SQL
3 votes95 views1 answer
Mysql insert on dupèlicate
SQL
28 votes101 views4 answers
Show tables mysql
SQL
0 vote105 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote105 views1 answer
Postgresql on conflict pair
SQL
0 vote117 views2 answers
Starts and end with vowel sql
SQL
6 votes102 views2 answers
Mysql convert timestamp to date
SQL
0 vote110 views1 answer
Redudancy in SQL
SQL
0 vote97 views1 answer
Sql show all users
SQL

Share