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 databases one by one. External security managers such as Apache Ranger (and I think Apache Sentry, but I'm not sure) can do blanket policies or default policies. This has the added advantage that as new databases are created the policies immediately apply. Alan. On Thu, Sep 13, 2018 at 10:37 PM Anup Tiwari <anupsdtiw...@gmail.com> wrote: > 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 >> >
