[teiid-issues] [JBoss JIRA] (TEIID-2578) add/remove schema elements

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2578:
---------------------------------------

It may not be necessary to explicitly perform a "CREATE ROLE", then we don't have to have both a ROLE and a DATA ROLE. Then it would match our existing logic better to have "CREATE ROLE <data role> [WITH JAAS ROLE string list]" - similar to postgres https://www.postgresql.org/docs/8.1/static/sql-createrole.html

We'd also need a DATABASE target for the GRANT as TEMP TABLES, LANGUAGE is global and ALL PRIVILEGES is optionally global.



> add/remove schema elements
> --------------------------
>
>                 Key: TEIID-2578
>                 URL: https://issues.jboss.org/browse/TEIID-2578
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 9.1
>
>
> Schemas are currently static after load.  Modifications can only happen with restarts or new versions.  We should allow add/drop at runtime.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)