[ https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin... ] 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} -- This message was sent by Atlassian JIRA (v6.4.11#64026)