DRAG DROP
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 displays 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 arrange them in the correct order.)
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/hh213020.aspx
http://msdn.microsoft.com/en-us/library/ms186819.aspx
http://msdn.microsoft.com/en-us/library/ms173846.aspx
I think that you also have to add statement 6 at the end. The question states that you need four statements and that you have to grant permissions for User1.
What do you guys think?
0
0
I think that if you’re altering the view then User1 still has the correct access. I reckon there’s a typo in the question and you only need 3.
0
0
Drop an create the view makes you to have to grant the user access. So using 1 you have to use 6 as well and then you already use 4 options as the question asks for. 1 + 5 + 4 + 6
0
0
YOU CAN ALSO START WITH DROPING THE VIEW AND RECREATING THE VIEW THEN ALL ..2…3 OPTIONS AND FINALLY ADD THE USER BACK
YOU GET 4-T-SQL STATEMENTS AS BEEN ASKED
THIS ONE REQUIRES MORE EFFORT THAN NECCESSARLY
0
0
2-5-4
0
0
I think the grant statement is wrong. Permission should be granted to the view not schema. even its granted at schema level, that does not appear to be the correct syntax. I’d 2-5-4, most likely there is a typo in the question, should be select 3
0
0
3=4 ???
0
0
2,5,4,6
0
0