• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

Problem with permissions on a view

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.
0
trwd
Asked:
trwd
1 Solution
 
rboyd56Commented:
The padlock indicates that the user cannot alter the view. It does not mean that it is encrypted. If you grant the alter permission on the view the padlock will disappear. You will have to revfresh the view collection for it to disappear

They should be able to select from the view event with the padlock visible.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now