Microsoft
70-459 · Question #92
You need to configure security on the Product table for customer support representatives. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
The correct answer is A. Create a view called CustProduct that includes columns ProductID. ProductName, E. GRANT SELECT on CustProduct TO OurDomain\CustomerSupport. Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario). GRANT ObjectPermissions (Transact-SQL)
Design and implement database security
Question
You need to configure security on the Product table for customer support representatives. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Options
- ACreate a view called CustProduct that includes columns ProductID. ProductName,
- BGRANT ALL on CustProduct TO OurDomain\CustomerSupport
- CCreate a user-defined data type called CustProduct that includes columnsProductID,
- DCreate a view called CustProduct that includes columns ProductID, ProductName,
- EGRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
- FGRANT SELECT on CustProduct TO public.
How the community answered
(64 responses)- A80% (51)
- B3% (2)
- C2% (1)
- D5% (3)
- F11% (7)
Explanation
Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario). GRANT ObjectPermissions (Transact-SQL)
Topics
#column-level security#views#GRANT permissions#role-based access
Community Discussion
No community discussion yet for this question.