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