Re: How to Grant All Privileges for All Databases except one in Hive SQL

If I needed to set the permissions for every table in every database and there were many, I'd write a shell script that first fetched all the databases and tables (using show databases, use database, and show tables) and then generated a "grant select on x" for each table. Assuming you don't want

Re: How to Grant All Privileges for All Databases except one in Hive SQL

Hive doesn't have a "grant select on db.*" option, which is what I think you're looking for here. Yes i am looking something like this only and since it is not available, does that mean i have to go for each table ? I am asking because we have many DBs and a lot of tables within each DB so is the

Re: How to Grant All Privileges for All Databases except one in Hive SQL

What you are seeing is correct behavior. Select on the database means the user can see objects in the database (ie, tables, views). To see contents of those objects you have to grant access on those objects. Hive doesn't have a "grant select on db.*" option, which is what I think you're looking

Re: How to Grant All Privileges for All Databases except one in Hive SQL

Hi Alan, I have given select access of a database to a role which is attached to a user but after this also that user is not able to execute select statements on tables of that database. But if i provide access at table level then that is working. Can you please help me here ? Hive Version : 2.3.

Re: How to Grant All Privileges for All Databases except one in Hive SQL

You can see a full list of what grant supports at https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-Grant There is no "grant x to user on all databases" or regex expressions for database names. So you'll have to do the databas

Re: How to Grant All Privileges for All Databases except one in Hive SQL

Hi, Can someone reply on this? On Tue, 11 Sep 2018 19:21 Anup Tiwari, wrote: > Hi All, > > I have similar requirement as mentioned in the link Link to question > > . > > *Requirem