StoneDeCroze
Programmer
Hi All,
I would like users to only be able to view data through views and NOT directly from the underlying tables as I want to filter out certain records.
However, if I set denydatareader on the table the users are get Access Denied when they open the views (even if they have read permissions to the view).
So, what security settings can I set on the views and tables to get this to work?
One possible problem: the views are in one Database and linked to tables in another.
Thanks for any help
Peter
I would like users to only be able to view data through views and NOT directly from the underlying tables as I want to filter out certain records.
However, if I set denydatareader on the table the users are get Access Denied when they open the views (even if they have read permissions to the view).
So, what security settings can I set on the views and tables to get this to work?
One possible problem: the views are in one Database and linked to tables in another.
Thanks for any help
Peter