/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 vote285 views1 answer
Sql count matching group by
SQL
0 vote299 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote294 views1 answer
Materialized view redshift
SQL
0 vote268 views1 answer
Default value false mysql
SQL
0 vote296 views1 answer
Connect by query in oracle
SQL
41 votes360 views6 answers
Alter table add column in SQL Server
SQL
3 votes277 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote281 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
7 votes271 views1 answer
Safe mode mysql
SQL
0 vote273 views1 answer
Postgresql alter column nullable
SQL

Share