/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 vote107 views1 answer
Mysql case when on date
SQL
0 vote128 views1 answer
How to get nth number in sql
SQL
8 votes116 views2 answers
Phpmyadmin default password
SQL
2 votes64 views1 answer
Sql select in list
SQL
0 vote131 views2 answers
What is rownum in oracle
SQL
0 vote112 views1 answer
Oracle last user logon
SQL
1 vote119 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote113 views2 answers
Oracle create chain rule
SQL
0 vote114 views1 answer
Drop tables from local database postgres pgadmin
SQL
3 votes121 views3 answers
How to add month in update sql
SQL

Share