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

Receive " User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures." error on unqualified SQL if data roles are active

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 7.4.1
    • 7.4.1, 7.6
    • Server
    • None

    Description

      If you run a query 'SELECT * FROM MyProc' i.e. without a model/schema name, You'll receive the below error if an all Access Data Role is assigned to the VDB. If you remove the Data Role, the query succeeds.

      Error: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures.
      SQLState: 50000
      ErrorCode: 0

      The query only succeeds if you fully qualify the proc/table when Data Roles are used.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-dsteigner Deborah Steigner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: