Re: BUG #5147: DBA can not access view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5147: DBA can not access view
Дата
Msg-id 6863.1257132736@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5147: DBA can not access view  ("hx.li" <fly2nn@126.com>)
Список pgsql-bugs
"hx.li" <fly2nn@126.com> writes:
> In postgresql's document£¬Part VI. Reference,SQL Commands,GRANT, it said:

> It should be noted that database superusers can access all objects
> regardless of object privilege settings.

What that means in this example is that the superuser can select from
the view, even if the view's owner tries to prevent that.  However,
the view itself doesn't have any more permissions than it had before.
It would have failed for anyone, and it fails for the superuser too.

I grow weary of debating this with you.

            regards, tom lane

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

Предыдущее
От: "hx.li"
Дата:
Сообщение: Re: BUG #5147: DBA can not access view
Следующее
От: "hx.li"
Дата:
Сообщение: Re: BUG #5147: DBA can not access view