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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2578:
-------------------------------------

The revised syntax would be

{code}
#create a data role
CREATE DATA ROLE <data-role>  [WITH JAAS ROLE <string>(,<string>)*]
 
#assign grants to data role
GRANT ( SELECT | INSERT |  UPDATE | DELETE | EXECUTE | LANGUAGE | ALTER | DROP | ALL PRIVILEGES | TEMP TABLES ) 
ON
   (
   DATABASE
   TABLE <schema-name>.<table-name>
    PROCEDURE <schema-name>.<proc-name>
    SCHEMA <schema-name>
    COLUMN <schema-name>.<table-name>.<col-name> [MASK [ORDER \d]  <string-val> ] [CONDITION [CONSTRAINT] <string-val>]
    )
TO <data-role-name>
{code}

> 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)