• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with SQL Server Views > Using Views to Secure Data

Using Views to Secure Data

One of the major benefits of a view is the security that it provides. Consider the following view:

CREATE VIEW vwEmployeeList 
AS 
SELECT EmployeeID, FirstName, LastName, Extension
FROM Employees


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint