Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6050

Unable to MASK data using odata-sample

    XMLWordPrintable

Details

    • Undefined

    Description

      According to the data roles documentation, I should be able to do this:

      CREATE DATABASE test VERSION '1.0.0';
USE DATABASE test VERSION '1.0.0';

CREATE ROLE user_role  WITH FOREIGN ROLE ROLE_user;

CREATE SERVER accounts FOREIGN DATA WRAPPER h2;
CREATE SCHEMA public SERVER accounts;

IMPORT FOREIGN SCHEMA PUBLIC FROM SERVER accounts INTO public;

GRANT SELECT ON TABLE public.ACCOUNT TO user_role;
GRANT SELECT ON COLUMN public.ACCOUNT.SSN
    MASK 'xxxx'
    TO user_role;

      Unfortunately I can't get it to work.

      I'm using a modified version of the odata sample from the spring-boot project. My modifications are:

      1. Add a dependency on spring-boot-starter-security
      2. Delete the tests (they break due to the dependency)
      3. Add the above SQL to a file called teiid.ddl in the resources folder
      4. Add the following lines to the application.properties
      spring.security.user.username=user
spring.security.user.password=user
spring.security.user.roles=user

      Attachments

        Issue Links

          is caused by

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIID-5798 Mixed PERMISSION GRANTS

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              alfborge Alf Lervåg (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: