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.
Answer: A, E
Explanation:
Give access to CustomerSupport through a view. The view must include all these columns (refer to scenario).