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?
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-03-31 15:18:08|
|Subject: Re: Grant select on view |
|Previous:||From: Jason Friedman||Date: 2002-03-31 03:30:39|
|Subject: Re: Backup|