Home / server / Questions / 278249
Accepted
Woot4Moo
Asked: 2010-08-03 09:27:29 +0800 CST

Postgres disable super user account

  • 772

How does one go about disabling a super user account within postgres without deleting it. I looked at the Alter Role documentation and I am drawing blanks. In addition this is the only super user account and the subordinate accounts own the tables that they are responsible for

postgresql

3 Answers

  1. Best Answer

    You could configure pg_hba.conf to reject the super user so it can't log in.

    • 4

  2. I assume that you have created a new user with super user privileges and you don't want to disable the postgres account, right?

    To disable an account try revoke:

    REVOKE ALL PRIVILEGES
ON DATABASE mydb
FROM mysuperuser;

    I might have missed something in the snippet above, check out the docs here: http://www.postgresql.org/docs/8.4/static/sql-revoke.html

    To remove the user, become super user yourself, ie postgres. Then use DROP ROLE:

    DROP ROLE mysuperuser;

    http://www.postgresql.org/docs/8.4/interactive/sql-droprole.html

    • 2

  3. There is always a superuser, you can't maintain your database without this role.

    • 1