Re: BUG #5214: Permission troubles for views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nikolay" <wheelly(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5214: Permission troubles for views
Date: 2009-11-26 15:33:16
Message-ID: 2068.1259249596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Nikolay" <wheelly(at)gmail(dot)com> writes:
> Description: Permission troubles for views

> SELECT * FROM "vw_data"; - permission denied for relation tbl_data. But
> permissions say that user_b can select from tbl_data and from vw_data.

This is not a bug. The view's reference to tbl_data is controlled by
the permissions of the owner of the view. If it didn't work like that,
a view couldn't be used as a permissions gateway.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Henrik Pestano 2009-11-27 03:15:40 BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"
Previous Message Walter Willmertinger 2009-11-26 10:41:23 BUG #5215: Error in PgAdmin