LGTM. Have we verified that the CTAS fails when the user doesn't have select privileges on the src table, especially when its qualified with the db name?
ACCESS-230: CREATE TABLE AS works even if user does not have DB-level access
Review Request #3436 - Created Aug. 8, 2013 and updated
The "create table as" is at table scope. Due to this we only validate the select part, but not the create part. Like normal create table, the CTAS also needs to be DB scope.
Added test cases for CTAS