Which two actions should you perform?

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.
A . Create a view called CustProduct that includes columns ProductI
B . ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierI
D . GRANT ALL on CustProduct TO OurDomainCustomerSupport
E . Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.
F . Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
G . GRANT SELECT on CustProduct TO OurDomainCustomerSupport.
H . GRANT SELECT on CustProduct TO public.

View Answer

Answer: A, E

Explanation:

Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario).