Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group