Support Questions

prakodi · ‎02-10-2023

Hi All,

I want to find out what are the roles / groups assigned to a DB / Schema in Hive, how I can get those details ? please suggest.

Thank you.

Regards,

PK

JoseManuel · ‎02-17-2023

PK,

If you have access to the Sentry Store backend use a query like this:

SELECT
r.ROLE_NAME,
g.GROUP_NAME,
p.*,
FROM_UNIXTIME(p.CREATE_TIME / 1000) as CREATE_TIME_DATE
FROM
SENTRY_ROLE r
INNER JOIN SENTRY_ROLE_GROUP_MAP rgm ON r.ROLE_ID = rgm.ROLE_ID
INNER JOIN SENTRY_GROUP g ON g.GROUP_ID = rgm.GROUP_ID
INNER JOIN SENTRY_ROLE_DB_PRIVILEGE_MAP rpm ON r.ROLE_ID = rpm.ROLE_ID
INNER JOIN SENTRY_DB_PRIVILEGE p ON p.DB_PRIVILEGE_ID = rpm.DB_PRIVILEGE_ID;

Hope it helps,

-JMP

View solution in original post

cdebernardi · ‎01-22-2025

I tested this in 7.1.9 SP1 CHF 4, with Postgres

Cloudera Community

Support Questions

How to find out the roles / groups assigned to a schema / DB in Hive

xa_audit_db_postgres.sql DB schema import failed!

DATABASE SETTING AFTER ASSIGNING ROLES

Accessing Hive Metastore DB on CDP Public Cloud

How to assign capacity scheduler queue based on AD...

Hive metastore DB Connection verification from Com...

Introduction into Process Group Variables

Knox can get LDAP user but can't find related grou...

Using the Schema Registry API

Adding new Ambari user with assigned group with AP...

Hive - top n records within a group