[teiid-issues] [JBoss JIRA] (TEIID-2578) add/remove schema elements
Ramesh Reddy (JIRA)
issues at jboss.org
Thu Aug 11 07:56:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13277832#comment-13277832 ]
Ramesh Reddy edited comment on TEIID-2578 at 8/11/16 7:55 AM:
--------------------------------------------------------------
proposed GRANT support to write data role information
{code}
#create a data role
CREATE DATA ROLE <data-role-name>
#to create a enterprise role, i.e. mapped role
CREATE ROLE <role-name>
#assign grants to data role
GRANT ( SELECT | INSERT | UPDATE | DELETE | EXECUTE | LANGUAGE | ALTER | DROP | ALL PRIVILEGES | TEMP TABLES )
ON
(
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>
# map data role(s) to a enterprise role
GRANT <data-role-name> (,<data-role-name>) TO <enterprise-role-name>
{code}
was (Author: rareddy):
proposed GRANT support to write data role information
{code}
#create a data role
CREATE DATA ROLE <data-role-name>
#to create a enterprise role, i.e. mapped role
CREATE ROLE <role-name>
#assign grants to data role
GRANT ( SELECT | INSERT | UPDATE | DELETE | EXECUTE | LANGUAGE | ALTER | DROP | ALL PRIVILEGES | TEMP TABLES )
ON
(
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>
GRANT <data-role-name> (,<data-role-name>) TO <enterprise-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)
More information about the teiid-issues
mailing list