/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

8 votes147 views1 answer
Oracle add months to sysdate
SQL
6 votes167 views2 answers
How to get yesterday date in mysql
SQL
1 vote156 views1 answer
Sql server today minus n
SQL
2 votes154 views5 answers
Tablespace ORACLE
SQL
6 votes153 views3 answers
Mysql first day of year
SQL
0 vote152 views2 answers
How to update the multiple rows in sql
SQL
9 votes147 views4 answers
Mysql show table fields
SQL
0 vote171 views1 answer
Mysql export data with a where clause
SQL
0 vote159 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote169 views1 answer
Oracle plan hash value
SQL

Share