09-09-2016 05:08 AM
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.
05-30-2017 04:44 PM
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