Postgres Pro
Downloads
Home   >   mailing lists

Re: I'm OWNER of the db but I get `permission denied` when - Mailing list pgsql-general

From Richard Huxton
Subject Re: I'm OWNER of the db but I get `permission denied` when
Date
Msg-id 4241945F.8010106@archonet.com
Whole thread Raw
In response to I'm OWNER of the db but I get `permission denied` when doing updating table pg_class ???? Any help appreciated  (David Gagnon <dgagnon@siunik.com>)
Responses Re: I'm OWNER of the db but I get `permission denied` when  (David Gagnon <dgagnon@siunik.com>)
Re: I'm OWNER of the db but I get `permission denied` when  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
David Gagnon wrote:
> Hi all,
>
> I just created a new db wich userX is owner.  I log via pgAdminIII with
> the same user but I can't update the pg_class.
>
> UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'
>
> I get:ERROR:  permission denied for relation pg_class
>
> I do that on my dev env.  The only difference I saw beetween users is
> that my DEV user as priviledge to create database(But it shouln't
> matter...?!)

I'm guessing your dev user is a superuser, and your other user isn't.
Don't forget pg_class isn't in your database, it's shared by all.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "A. Mous"
Date:
Subject: Re: Simple query takes a long time on win2K
Next
From: Edson Vilhena de Carvalho
Date:
Subject: backend process