To retrieve metadata from the Hive metastore during a session, a temporary view must be created in the default or temporary database specified in the Hive connector property Temporary Database Name (tempdb). Temporary views are created with limit 0 so no one can use the temporary views to access data during the short period of time the temporary view exists. Users require CREATE VIEW and DROP VIEW access to the default or temporary database.