/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 vote114 views1 answer
Soql user profile
SQL
2 votes121 views1 answer
Add default sql server
SQL
0 vote128 views4 answers
How to connect form to database
SQL
0 vote113 views1 answer
Authentication in sql server
SQL
1 vote125 views1 answer
Psql search table
SQL
-2 votes122 views1 answer
Remove root password mysql
SQL
0 vote123 views1 answer
Sql query to force the database to be drop
SQL
0 vote122 views1 answer
Sqlcmd no headers
SQL
0 vote107 views1 answer
Show table structure mysql console
SQL
5 votes119 views1 answer
Oracle sysdate
SQL

Share