Grant select on view

From: thiemo <thiemo(at)gmx(dot)ch>
To: pgNovice <pgsql-novice(at)postgresql(dot)org>
Subject: Grant select on view
Date: 2002-03-31 08:32:55
Message-ID: E5D03356-4481-11D6-BA58-000A27D62F9E@gmx.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I try encapsulate my db in views such that users access it by the views
and only get to see the rows they are allowed to. However, I created a
view and put select select ricghts on it for the respective users, but a
select on it ends up with a permission denied. So, I granted select
rights on the base table, but to no avail. A select by the users on the
base table is no possible, but on the view it stays denied.

What have I overlooked?

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-03-31 15:18:08 Re: Grant select on view
Previous Message Jason Friedman 2002-03-31 03:30:39 Re: Backup