You can grant read access to a view while revoking access to the base table. Updatable views however, require update access to the base tables.
Are You a SQL Server Master?Commented on: 6 years ago
(July 17, 2008)
Interesting article...but when it comes to certifications I don't value them too highly.
Sadly, I have worked with people who have have studied and studied to pass their Microsoft SQL Server...
How Sun's Acquisition of MySQL Will Affect SQL ServerCommented on: 6 years ago
(April 24, 2008)
I have been using MySQL for a year now as a database back end for various websites I operate. Although I am much more familiar with SQL Server (13 years!) I really do appreciate what you can do with...
Stored Procedure Documents Scheduled Jobs in SQL ServerCommented on: 6 years ago
(March 4, 2008)
This stored procedure has been tested on a variety of SQL Server installations and has been running without error for years (the original code was developed in 2002 for SQL 2000).
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More