[JBoss JIRA] Created: (TEIIDDES-568) Provide the ability to control the data role access to the system tables
by Ramesh Reddy (JIRA)
Provide the ability to control the data role access to the system tables
------------------------------------------------------------------------
Key: TEIIDDES-568
URL: https://jira.jboss.org/browse/TEIIDDES-568
Project: Teiid Designer
Issue Type: Task
Components: VDB & Execution
Reporter: Ramesh Reddy
Currently the Designer does not provide a mechanism to control the system tables through "data roles" wizard. This needs to be provided. Since the system tables are read only these guys only need "readonly" permission. Since the "pg_catalog" is also another variation of "system" tables that needs to controlled also. However, "pg_catalog" is dynamic view model added during the deployment time and Designer does not have access to it.
Since
1) providing the fine grained control over system schema is error prone in providing metadata or not
2) pg_catalog is not available
we propose that this metadata on tooling is controlled through single boolean field (check box) called "Allow access to system tables". The default of this should be "true"
As result of checking this box, the following XML fragment needs to be vdb.xml file
<permission>
<resource-name>sys</resource-name>
<allow-create>false</allow-create>
<allow-read>true</allow-read>
<allow-update>false</allow-update>
<allow-delete>false</allow-delete>
</permission>
<permission>
<resource-name>pg_catalog</resource-name>
<allow-create>false</allow-create>
<allow-read>true</allow-read>
<allow-update>false</allow-update>
<allow-delete>false</allow-delete>
</permission>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 8 months
[JBoss JIRA] Created: (TEIIDDES-512) Add "materializedTable" to Relational Table metamodel class
by Barry LaFond (JIRA)
Add "materializedTable" to Relational Table metamodel class
-----------------------------------------------------------
Key: TEIIDDES-512
URL: https://jira.jboss.org/browse/TEIIDDES-512
Project: Teiid Designer
Issue Type: Task
Components: Modeling
Affects Versions: 7.1
Reporter: Barry LaFond
Assignee: John Verhaeg
Priority: Blocker
Fix For: 7.1
In order to make materialization work within EMF and Designer, the Relational metamodel needs to be tweaked to allow for a "materializedTable" reference (EObject) to be stored on the Table or BaseTable objects.
This will insure that an "external" href object will be persisted with the View model, a model import will be created (dependency) AND when the View model is added to a VDB, the Materialized (physical) model will be auto-added to the VDB as well.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 8 months