Hi, Can someone reply on this?
On Tue, 11 Sep 2018 19:21 Anup Tiwari, <anupsdtiw...@gmail.com> wrote: > Hi All, > > I have similar requirement as mentioned in the link Link to question > <https://stackoverflow.com/questions/38199021/how-to-grant-all-privileges-for-all-databases-except-one-in-hive-sql> > . > > *Requirement :-* > > I know how to grant privileges on a database to a role in Hive SQL. > For example, GRANT ALL ON DATABASE analyst1 TO ROLE analyst_role; > But there are hundreds of databases on my system, it's almost impossible > to grant one by one. > Is it possible to grant all privileges for all databases ? > Also Is it possible to grant all privileges for all databases except one > database(ex: db.name = temp)? > > > Regards, > Anup Tiwari >
