/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

17 votes367 views4 answers
Show all tables in oracle
SQL
0 vote296 views1 answer
Get who is hired in january in sql
SQL
0 vote309 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote294 views1 answer
Update set with inner join oracle
SQL
0 vote308 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote290 views1 answer
Mysql show foreign keys column
SQL
0 vote298 views1 answer
Add SuperUser MySQL
SQL
0 vote335 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote334 views1 answer
Move table to a different schema
SQL
2 votes324 views1 answer
Mysql increment value by 1 in update
SQL

Share