You are a database developer for a large travel company. You have been granted CREATE VIEW
permissions in the Reservations database. Your co-worker, Eric, has been granted CREATE TABLE
permissions. Neither of you have been given database owner or system permissions, nor have you been
added to any fixed server roles.
Eric has created a table named Traveler that holds information about your company's customers. This
table is shown in the exhibit. .
Travel agents will connect to the database and view the information stored in this table. The database
logins for the travel agents have been assigned to the Agent database role.
You want the travel agents to be able to view the name and address information from the Traveler table
in two columns instead of six. One column should contain the traveler name and the other column should
contain the address.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three)
A. Grant the Agent role SELECT permissions on the Traveler table.
B. Instruct Eric to grant the Agent role SELECT permissions on the Traveler table.
C. Instruct Eric to grant you REFERENCES permissions on needed columns in the Traveler table.
D. Instruct Eric to create a view named vwTravelers that displays the data in the desired format.
E. Create a view named vwTravelers that displays the data in the desired format.
F. Grant the Agent role SELECT permissions on the vwTravelers view.