Help: Dumb newbie locked himself out!

From: "Balazs Wellisch" <balazs(at)bwellisch(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Help: Dumb newbie locked himself out!
Date: 2002-07-17 16:51:01
Message-ID: JPEOKLNNLDPGJFFAAFLNIEODCPAA.balazs@bwellisch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello all,

sorry for the dumb question but I managed to mess up the privileges in my
database and now I'm unable to create or modify any users. I can still
connect to my database using the postgres user but I don't have the
permissions to do anything. How can I reset the permissions so that the
postgres user will have full access again?

This is a RedHat Linux 7.2 machine running PostgreSQL 7.1.3, standard RPM
installation of everything.

Thank you for you help in advance,

Balazs

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message D. Duccini 2002-07-17 16:52:54 Re: mirroring databases
Previous Message April L 2002-07-17 16:48:41 mirroring databases