[teiid-issues] [JBoss JIRA] (TEIID-2327) Add column masking

Fri May 3 13:43:53 EDT 2013

    [ https://issues.jboss.org/browse/TEIID-2327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12772016#comment-12772016 ] 

Steven Hawkins commented on TEIID-2327:
---------------------------------------

Added the initial implementation - masks are allowed on views/tables/procedures and are applied logically after row based filters.  It is undefined as to which mask is used if multiple roles specify masks against the same column with the same order value.

The initial support also has the limitation of not supporting subqueries in column masks (just as with conditions as checked constraints).  I'll look to address both of those as we move toward the final release.

Also moved caching of the parsed/resolved/validated masks/filters onto the permission rather than the metadata.  Also corrected another issue with caching - that is the previous logic did not clone what was put into the cache, thus in some circumstances invalid objects (planned against a specific plan) will be in the cache for 8.3.

> Add column masking
> ------------------
>
>                 Key: TEIID-2327
>                 URL: https://issues.jboss.org/browse/TEIID-2327
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.4
>
>
> Support for column masking should be added to data roles.  A typical approach would be to only affect the final projected values from user queries and have only one mask applicable at a time.
> A possibly related ability would be to hide columns (much like hidden tables) to our metadata.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira