Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1979

Changes to a table's columns can result in role being reset for the entire model - 7.7.x

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.3
    • 7.7, 8.2
    • None
    • None
    • Hide

      1) Create a project with a single virtual model with the below schema:

      model1
      -> table1a
      ---> column1a1
      ---> column1a2
      -> table1b
      ---> column1b1
      ---> column1b2

      2) Define a role on the table, removing read permissions from 'column1a2'.
      3) Save all changes.
      4) Rename column 'column1b2' to 'uselessColumn', leaving a schema like below:

      model1
      -> table1a
      ---> column1a1
      ---> column1a2
      -> table1b
      ---> column1b1
      ---> uselessColumn

      5) Save changes and synchronize the VDB.
      6) Edit data role to see that the permissions have defaulted and 'column1a2' now has read permissions

      Show
      1) Create a project with a single virtual model with the below schema: model1 -> table1a ---> column1a1 ---> column1a2 -> table1b ---> column1b1 ---> column1b2 2) Define a role on the table, removing read permissions from 'column1a2'. 3) Save all changes. 4) Rename column 'column1b2' to 'uselessColumn', leaving a schema like below: model1 -> table1a ---> column1a1 ---> column1a2 -> table1b ---> column1b1 ---> uselessColumn 5) Save changes and synchronize the VDB. 6) Edit data role to see that the permissions have defaulted and 'column1a2' now has read permissions

      I have a model like below with a role defined to remove read privileges on 'column1a2' only.

      model1
      -> table1a
      ---> column1a1
      ---> column1a2
      -> table1b
      ---> column1b1
      ---> column1b2

      I adjust the model to rename 'column1b2' to 'uselessColumn':

      model1
      -> table1a
      ---> column1a1
      ---> column1a2
      -> table1b
      ---> column1b1
      ---> uselessColumn

      The role is reset and now has default read privileges defined across the entire model. I have to manually edit the role to reset it to the prior defined permissions.

              rhn-support-jolee Johnathon Lee
              rhn-support-mshirley Marc Shirley (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: