Frank is a member of the Windows Active Directory group Sales. Sales has been granted Select permission on the entire SalesHist database. Frank is also a member of the Management group. Management has been granted Insert permission on only certain tables SalesHist. A new tables names SalesByNation has just been created for internation sales. Which statement is true?
(Frank as a member of Sales will be able to SELECT data. Frank cannot INSERT data as neither his user ID, the Sales group or the Management group, have been granted the INSERT permission on this new table.)