My Oracle Support Banner

"SemanticException Sentry does not allow privileges to be granted/revoked to/from: USER" Raised with Sentry on Oracle Big Data Appliance (Doc ID 2145514.1)

Last updated on JANUARY 28, 2020

Applies to:

Big Data Appliance Integrated Software - Version 4.3.0 and later
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

When using the bdaadmin account, which is a sentry account, it is not possible to grant permissions to a group.  The follow error occurs in beeline:

# beeline
Beeline version 1.1.0-cdh5.4.7 by Apache Hive
beeline> !connect jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/default;principal=hive/<HOSTNAME4>.<DOMAIN>@<REALM>
scan complete in 1ms
Connecting to jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/default;principal=hive/<HOSTNAME4>.<DOMAIN>@<REALM>
Enter username for jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/default;principal=hive/<HOSTNAME4>.<DOMAIN>@<REALM>:
Enter password for jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/default;principal=hive/<HOSTNAME4>.<DOMAIN>@<REALM>:
Connected to: Apache Hive (version 1.1.0-cdh5.4.7)
Driver: Hive JDBC (version 1.1.0-cdh5.4.7)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/d>
0: jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/d>
0: jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/d>
0: jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/d> grant select on table <TABLENAME> to user bdaadmin;
Error: Error while compiling statement: FAILED: SemanticException Sentry does not allow privileges to be granted/revoked to/from: USER (state=42000,code=40000)
0: jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/d>

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.