Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sentry query to know the group or role for a particular database.

Highlighted

Sentry query to know the group or role for a particular database.

Explorer

Hi All,

 

Is there any sentry command which shows which database belongs to which group or role?

 

I have tried below commands but it gives error:-

 

show grant role on database db1;
Error: Error while compiling statement: FAILED: ParseException line 1:16 cannot recognize input near 'on' 'database' 'db1' in user|group|role name (state=42000,code=40000)

 

show grant group on database db1;
Error: Error while compiling statement: FAILED: ParseException line 1:17 cannot recognize input near 'on' 'database' 'db1' in identifier for principal spec (state=42000,code=40000)

 

Also, there is no permission issue here, I have the admin privilege to run all the commands.

 

Thanks in advance.

1 REPLY 1

Re: Sentry query to know the group or role for a particular database.

Explorer

Hi, I would like to be able to find the same information. I really need to be able to query it from a database. I thought it might be available in the Sentry or the Hive back end databases but I just can find anything.  Is anyone able to offer any solutions

Don't have an account?
Coming from Hortonworks? Activate your account here