Grant select on view

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

<fontfamily><param>Helvetica</param>

--

Thiemo Kellner

Tösstalstrasse 146

CH-8400 Winterthur

</fontfamily>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