This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
postgresql [2018/08/27 13:41] mantis |
postgresql [2020/07/15 09:42] (current) mstraub |
||
---|---|---|---|
Line 44: | Line 44: | ||
# set a password | # set a password | ||
\password | \password | ||
+ | |||
+ | # make an existing user superuser (or remove superuser rights) | ||
+ | sudo -u postgres psql -c "ALTER USER theuser WITH SUPERUSER;" | ||
+ | sudo -u postgres psql -c "ALTER USER theuser WITH NOSUPERUSER;" | ||
# create a restricted user with password (long and short version) | # create a restricted user with password (long and short version) |