Unable to run Hive CTAS query if user has no write permission on current database

The following was what happens when user hit the issue: user has WRITE permission on database schema1 user has ONLY READ permission on database schema2 user is currently on database schema2, so the result of after running the query: USE schema2; user is trying to run the following query: CREATE …