Security on Win2k

[StoneDeCroze]

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

 

[StoneDeCroze]

Win2k? Brain Haemorrhage.

I mean SQL 2000.

Sorry for the confusion,

Peter