You create a view based on the following statement:
You grant the Select permission to User1 for this view. You need to change the view so that it display s only the
records that were processed in the month prior to the current month. You need to ensure that after the
changes, the view functions correctly for User1. Which four Transact-SQL statements should you use? (To
answer, move the appropriate SQL statements from the list of statements to the answer area and arrangethem
in the correct order.)
Answer:
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/hh213020.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms186819.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms173846.aspx
