title: How to Grant All Privileges for All Databases except one in Hive SQL
body: <p>I know how to grant privileges on a database to a role in Hive SQL.</p>
  
  <p>For example, 
      GRANT ALL ON DATABASE analyst1 TO ROLE analyst_role;</p>
  
  <p>But there are hundreds of databases on my system, it's almost impossible to grant one by one.</p>
  
  <p>Is it possible to grant all privileges for all databases except one database(ex: db.name = temp)?</p>