title: DB2 Grant Permissions (like SELECT/INSERT/etc) to all tables of a schema
body: <p>I am currently working on some DB2 work which requires me to grant the following privileges to all the tables within a schema:</p>
  
  <p><code>
  GRANT
    SELECT,
    INDEX,
    INSERT,
    UPDATE,
    DELETE,
    CREATE,
    DROP,
    ALTER,
    CREATE TEMPORARY TABLES
  ON MY_SCRATCH_SCHEMA.* to 'MY_USER'@'%';
  </code></p>
  
  <p>The above is a query for MySQL, however, I need to rewrite it for DB2. </p>
  
  <p>As far as I know, there's no command to grant those permissions to all tables of a schema, you must rely on a procedure. But knowing it's DB2, there's documentation that's all over the place that works for different versions of DB2, so I am a little not trusting of what's online. </p>
  
  <p>So my question is - how do I rewrite the above query for DB2?</p>