Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-2664

filterListCmdObjects does not work in sql 'show databases'

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.2.0
    • None
    • plugins
    • None

    Description

      In hive plugin, when execute sql 'show databases', 

      privilege HiveAccessType.USE is required on database '*'.  If it is authorized USE privilege, all database will be showed. If not, the sql will be stuck when checking privilege.

      To solve the problem, just let the sql 'show databases' pass through when METASTORE_FILTER_HOOK is set as AuthorizationMetaStoreFilterHook. Privilege HiveAccessType.USE is not required on database '*'.

      Attachments

        1. Ranger-2664-1.2.patch
          4 kB
          star
        2. Ranger-2664-1.2-PermissionDenied.patch
          2 kB
          star
        3. ranger-2664.patch
          2 kB
          star

        Activity

          People

            starphin star
            starphin star
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: