Re: I'm OWNER of the db but I get `permission denied` when

Поиск
Список
Период
Сортировка
От David Gagnon
Тема Re: I'm OWNER of the db but I get `permission denied` when
Дата
Msg-id 42419982.9050406@siunik.com
обсуждение исходный текст
Ответ на Re: I'm OWNER of the db but I get `permission denied` when  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Thanks It's the problem.

/David

Richard Huxton wrote:

> 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.
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: backend process
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Simple query takes a long time on win2K