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

2018-09-21 Thread Alan Gates
gt;> Regards, >>> Anup Tiwari >>> >>> >>> On Fri, Sep 14, 2018 at 10:50 PM Alan Gates >>> wrote: >>> >>>> You can see a full list of what grant supports at >>>> https://cwiki.apache.org/confluence/display/Hive/SQL+Standa

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

2018-09-17 Thread Anup Tiwari
t;>> 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&#x

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

2018-09-17 Thread Alan Gates
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 Tiwar

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

2018-09-17 Thread Anup Tiwari
8 at 10:37 PM Anup Tiwari > wrote: > >> 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

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

2018-09-14 Thread Alan Gates
018 at 10:37 PM Anup Tiwari wrote: > 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 >> <https://stackoverflow.com/questions/381

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

2018-09-13 Thread Anup Tiwari
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 > <https://stackoverflow.com/questions/38199021/how-to-grant-all-privileges-for-all-databases-except-

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

2018-09-11 Thread Anup Tiwari
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 e