/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

2 votes346 views1 answer
Revokeprivileges mysql
SQL
0 vote327 views1 answer
Oracle query archivemode
SQL
0 vote348 views3 answers
Postgres date difference seconds
SQL
0 vote302 views1 answer
How to insert same table data using mysql query
SQL
0 vote329 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote346 views1 answer
Procedure excute monthly oracle
SQL
5 votes322 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote331 views1 answer
How to get data from 2 database
SQL
4 votes322 views3 answers
Sqlite show columns
SQL
6 votes374 views5 answers
Oracle list tablespaces
SQL

Share