[JBoss JIRA] (TEIIDDES-2638) Problem with New Model Wizard
by stanislav kaleta (JIRA)
stanislav kaleta created TEIIDDES-2638:
------------------------------------------
Summary: Problem with New Model Wizard
Key: TEIIDDES-2638
URL: https://issues.jboss.org/browse/TEIIDDES-2638
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.3
Reporter: stanislav kaleta
In New Model Wizard, there are incompatible first and second page (see steps to reproduce).
Changes of Model Class is not applying to second page.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2624:
---------------------------------------
I think some users use the update flag as a means to establish a READ-ONLY database, like Oracle, as way to setup a report only database. This way it guarantees the usage and eliminates/simplifies some of the administration that would be needed.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2624:
------------------------------------------
It should be up to the import process to set the updatable flag. Generally it is not something you would then edit. As Ramesh says data roles are for security, but yes in the past given the overhead of utilizing data roles users could set to not updatable.
In DDL insert/update/delete procedures are instead of triggers that fire for each row. You can see the syntax in the grammar.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2624:
----------------------------------------
[~rareddy] So should we eliminate that property all together for source models and assume always TRUE or FALSE? Just go with data roles to control/fine-tune all updates? Though View models would still need "Supports Update" so INSERT/UPDATE/DELETE SQL could be defined, wouldn't they?
On a side note... how would users convet from custom INSERT/UPDATE/DELETE SQL in a *.vdb into DDL in a -vdb.xml ??
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2624:
----------------------------------------
[~van.halbert] No it is not just Designer, this results in metadata, that flows into VDB that user operates on.
Let me explain, little differently to help ease your concerns. The "updatable" flag on the metadata is not there to prohibit somebody to write to it, it is there is define the capability of the table whether it is capable of accepting the update commands or not. The notion of security is only need to be handled by the "data-roles". They both are seperate concerns. We need to keep them separate and not mixed up.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2624:
---------------------------------------
We're only talking Designer here.
Even thought I don't like the default, I can understand its been there for years (but that doesn't make it right).
As for changing it, it would only impact new imports. Nothing that's been created would be impacted.
But at a minimum, we need an option at import time to change the default for all imported tables.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2624:
----------------------------------------
I do not understand your logic, you wan't to change something on your perceived notion of threat, which was working fine for everyone else for this long?
If you want to provide an option to user that is fine, but do not change the default from TRUE to FALSE.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2624:
----------------------------------------
As [~blafond] mentions this has been default from beginning, we have other mechanics like not data-roles that will prohibit user from doing harm, and visibility flag too to hide. I would not go changing this now, you do not know how many deployments this will break, which are coded on this assumption.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months