Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Per the discussion of DRILL-4577, for INFORMATION_SCHEMA query
select TABLE_CATALOG, TABLE_SCHEMA , TABLE_NAME, TABLE_TYPE from INFORMATION_SCHEMA.`TABLES` ...
Drill's current behavior under Storage-based and Sql-standard impersonation is different.
1. Under storage-based mode, the above query will only return the tables the user has access.
2. Under sql-standard mode, the above query will return tables the user does not have access.
Either Drill should correct the behavior of sql-standard mode, or Drill should do something to make the two modes behavior consistently.