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

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