ACCESS-230: CREATE TABLE AS works even if user does not have DB-level access

Review Request #3436 - Created Aug. 8, 2013 and updated

Prasad Mujumdar
old-access
master
ACCESS-230
access
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
  1. 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?
    1. We have a test cases for cross db in TestSandboxOps and TestPrivilegesAtDatabaseScope. A added another one for the cross DB DDL privilege check.
  2. 
      
  1. Ship It!
  2. 
      
Loading...