Here's my problem - I want our normal SQL users, called 'WebUser' to be able to view a view called 'sjView'...However, the table(s) this view is made up of is not accessible by WebUser, hence causing a permissions error when trying to look at it. I tried to give the view SELECT permissions etc to WebUser, but this didn't work - It just allowed me to view the view code etc.
Overall, what I want is WebUser to be able to view the sjView table, but not the tables it derives from.
Thanks, that worked nicely! I never did GRANT SELECT ON [sjView] TO [Webuser], but I did give sjView SELECT permissions to Webuser from Enterprise Manager, which I presumed would do the same thing. What's the difference?