Problem with permissions on a view
Posted on 2007-03-28
I have created a view that utilizes a linked server to get information from another server. I am using a remote access login for the linked server. The problem is that even though I have assigned select premissions to my other users, they can't access the view. When I login into management studio as other users I see that the view is listed as an object but the icon changes to one with padlock on it which means the view is encrypted to the user. I did not add the "With Encryption" clause to my create view script so I am about ready to tear my scalp off(since I already have no hair). The weird thing is that when i assign my users to the dbo role, the view magically becomes not encrypted so they can access it. PLEASE HELP experts.