Re: BUG #5147: DBA can not access view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "hx(dot)li" <fly2nn(at)126(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5147: DBA can not access view
Date: 2009-11-02 03:32:16
Message-ID: 6863.1257132736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"hx.li" <fly2nn(at)126(dot)com> writes:
> In postgresql's documentPart 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hx.li 2009-11-02 05:36:41 Re: BUG #5147: DBA can not access view
Previous Message hx.li 2009-11-02 02:21:18 Re: BUG #5147: DBA can not access view