/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 vote324 views1 answer
Display first three characters sql
SQL
-1 vote299 views1 answer
How to format tables in sqlplus
SQL
6 votes383 views2 answers
How to get last element sql
SQL
6 votes325 views4 answers
Eloquent to sql with bindings
SQL
0 vote332 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes358 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote328 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote357 views1 answer
Sql injection payload list github
SQL
0 vote331 views1 answer
User defined variables in sql
SQL
1 vote337 views2 answers
Postgres copy table from one schema to another
SQL

Share