/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

6 votes405 views6 answers
Rename column postgres
SQL
0 vote392 views1 answer
Reindex mssql table
SQL
0 vote338 views1 answer
Database springboot
SQL
0 vote358 views1 answer
Table or view does not exist
SQL
1 vote365 views3 answers
What is union in sql
SQL
36 votes368 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote335 views1 answer
Automatically update database last seen datetime in sql
SQL
19 votes359 views4 answers
Rename database in sql
SQL
0 vote375 views1 answer
Sql quary intervewi question
SQL
5 votes391 views4 answers
Traduction
SQL

Share