Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Problem with permissions on a view

Posted on 2007-03-28
1
253 Views
Last Modified: 2013-11-30
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
Comment
Question by:trwd
1 Comment
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18808553
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question