[teiid-issues] [JBoss JIRA] Commented: (TEIID-89) Data roles should account for the ability to create temp tables

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-89?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569328#comment-12569328 ] 

Steven Hawkins commented on TEIID-89:
-------------------------------------

In thinking about this more, it seems like we should be more explicit.  Following mysql both create/drop and all dml statements should be covered by something like the CREATE_TEMPORARY_TABLES permission type.  However the way our datapolicy logic works, it will be simpler to implement as an attribute of the policy (like anyauthenticated).

Done this way there is no confusion or potential conflicts, but we will have to update the designer logic to add another check box.


> Data roles should account for the ability to create temp tables
> ---------------------------------------------------------------
>
>                 Key: TEIID-89
>                 URL: https://issues.jboss.org/browse/TEIID-89
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Optional
>             Fix For: 7.3
>
>
> Defect Tracker #24698: Data roles should account for creating temp tables.  Right now all temp table creation is allowed.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira