Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5837 SQL standard based secure authorization for hive
  3. HIVE-6252

sql std auth - support 'with admin option' in revoke role metastore api

    XMLWordPrintableJSON

Details

    • Hide
      Adds support for "ADMIN OPTION FOR" in revoke role.
      It lets you revoke the ADMIN OPTION of a user on a role. The user remains a member of that role.
      eg -
      revoke admin option for src_role_wadmin from user user2;
      Show
      Adds support for "ADMIN OPTION FOR" in revoke role. It lets you revoke the ADMIN OPTION of a user on a role. The user remains a member of that role. eg - revoke admin option for src_role_wadmin from user user2;

    Description

      The metastore api for revoking role privileges does not accept 'with admin option' , though the syntax supports it. SQL syntax also supports grantor specification in revoke role statement.

      It should be similar to the grant_role api.

      Attachments

        1. HIVE-6252.1.patch
          578 kB
          Jason Dere
        2. HIVE-6252.2.patch
          578 kB
          Jason Dere
        3. HIVE-6252.3.patch
          579 kB
          Jason Dere

        Issue Links

          Activity

            People

              jdere Jason Dere
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 24h
                  24h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified