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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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?



Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur


pgsql-novice by date

Next:From: Tom LaneDate: 2002-03-31 15:18:08
Subject: Re: Grant select on view
Previous:From: Jason FriedmanDate: 2002-03-31 03:30:39
Subject: Re: Backup

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