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.
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
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.