/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

14 votes153 views5 answers
Sql oracle limit
SQL
13 votes161 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote182 views1 answer
Sql insert from excel
SQL
-1 vote156 views1 answer
How to create foreign key in sql server management studio
SQL
4 votes153 views2 answers
Insert current date in mysql
SQL
0 vote145 views1 answer
Array aggre distinct postgres
SQL
103 votes395 views2 answers
Sql server LIKE '%%'
SQL
0 vote158 views1 answer
Sql search all columns of database oracle sql
SQL
4 votes149 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote159 views1 answer
How to select multiple columns from different tables in mysql
SQL

Share