[teiid-issues] [JBoss JIRA] (TEIID-1738) Temp table permissions can be confusing

Temp table permissions can be confusing --------------------------------------- Key: TEIID-1738 URL: https://issues.jboss.org/browse/TEIID-1738 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 The checking of temptable permissions currently returns the first non-null permission from the role set. This is different than the additive behavior of all other permissions. It means that setting a role to explicitly not be able to create temp tables may inappropriately deny a user from creating temp tables if a later role explicitly grants the permission. The permission determination logic should be: if any role allows return allow if any role doesn't allow return not allowed return the allowCreateTempTablesByDefault setting