Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-256 Integrate Security with Apache Ranger
  3. HAWQ-1257

If user doesn't have privileges on certain objects, need return user which specific table he doesn't have right.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.0.0-incubating
    • Component/s: Security
    • Labels:
      None

      Description

      If user doesn't have privileges on certain objects, need return user all the objects he doesn't have right, to avoid the user modify one privilege, and then find another privilege constraint, and then another... which may bother the user a lot.

      For example:
      user didn't have the rights of t1 and t2.

      postgres=> select * from test_sa.t1 left join test_sa.t2 on test_sa.t1.i=test_sa.t2.i;
      ERROR:  permission denied for relation t1
      

      We wish to prompt user didn't have the rights of t2 also.

        Attachments

          Activity

            People

            • Assignee:
              hongxu ma Hongxu Ma
              Reporter:
              lilima Lili Ma
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: