Reply
Highlighted
Explorer
Posts: 14
Registered: ‎02-10-2015

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

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.

Explorer
Posts: 13
Registered: ‎05-03-2017

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

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

Announcements