Re: BUG #5147: DBA can not access view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5147: DBA can not access view
Date
Msg-id 6863.1257132736@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5147: DBA can not access view  ("hx.li" <fly2nn@126.com>)
List 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 by date:

Previous
From: "hx.li"
Date:
Subject: Re: BUG #5147: DBA can not access view
Next
From: "hx.li"
Date:
Subject: Re: BUG #5147: DBA can not access view