- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SWICHDATABASE privilege missing error in HUE. User can't access to Hive tables.
Created on ‎11-22-2017 04:08 AM - edited ‎09-16-2022 05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SWITCHDATABASE privilege missing when trying to run a select
Privileges the user has.
Working in Hue, I want this user "user" to access Hive tables.
As seen in the images, in the context of a proof of concept. User have privilege to any action on the server. However, when I try to run a simple select * in Hue, I got a SWITCHDATABASE missing privilege error.
Created on ‎11-27-2017 05:02 AM - edited ‎11-27-2017 05:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SOLVED
So I skipped to add the user/group to the unix system...
groupadd reg_group useradd -g reg_group user_reg
Created ‎11-26-2017 12:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created ‎11-26-2017 12:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created on ‎11-27-2017 03:02 AM - edited ‎11-27-2017 03:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created on ‎11-27-2017 05:02 AM - edited ‎11-27-2017 05:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SOLVED
So I skipped to add the user/group to the unix system...
groupadd reg_group useradd -g reg_group user_reg
Created ‎05-17-2023 11:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where do you get/access to this kind of UI? I'm stuck with the user-group thingy when working with Sentry too.
