Hello- I've created a view as 'sa' but other users cannot access it. Symptoms are 1) Crystal Locks Up. 2) Querying the view thru Query Analyzer runs forever. 3) Clicking on Table Columns in Query Analyzer takes a while and then shows nothing and the + symbol disappears as if the table had no columns??? I've checked and users have select access to underlying tables and the view. It runs fine with any DBA login. And the other wierd thing is that pasting the create view script into anther window and removing "create view viewname as" part and then running it works fine. I've done this many times before and never had this problem. What do you think?
Thanks
Chris
Thanks
Chris