Postgres Pro
Downloads
Home   >   mailing lists

Help: Dumb newbie locked himself out! - Mailing list pgsql-novice

From Balazs Wellisch
Subject Help: Dumb newbie locked himself out!
Date
Msg-id JPEOKLNNLDPGJFFAAFLNIEODCPAA.balazs@bwellisch.com
Whole thread Raw
In response to Re: Newbie Stupid Question  (AarniRuuhimäki / Megative Tmi / KYMI.com<aarni.ruuhimaki@kymi.com>)
Responses Re: Help: Dumb newbie locked himself out!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: mirroring databases
Next
From: Tom Lane
Date:
Subject: Re: Help: Dumb newbie locked himself out!