Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5332

Add a built in function to determine if a user is in a given role

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Backend
    • Labels:
    • Epic Color:
      ghx-label-7

      Description

      It is possible to get the user() and effective_user(), however it is not possible to determine the users role.

      Implement a mechanism to test that a user is within a certain role.
      This function should return inline and be efficient.

      Should be testable within a WHERE clause, providing per row-filtering within a view or query.

      Alternatively provide a mechanism where the SHOW CURRENT ROLES function returns a table that can be used inline as a join with other tables.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              royles Christopher Royles
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: