title: How do I create a Oracle trigger that grants permissions
body: <p>I want to do something that's conceptually simple but seems to be a lot more complex in reality.</p>
  <p>Basically, whenever a new table is created for a couple of users in our database, I want to grant select permissions to a role. Basically this:</p>
  <p><code>grant select on TABLENAME to READROLE;</code></p>
  <p>So far my trigger looks something like this:</p>
  <blockquote>
  <p>CREATE OR REPLACE TRIGGER osmm_grant_on_creation</p>
  <p>AFTER CREATE ON OSMM.SCHEMA</p>
  <p>BEGIN</p>
  <pre><code>    //grant goes here
  </code></pre>
  <p>END</p>
  </blockquote>
  <p>Problem is, I can't figure out how to join the two together by getting the name of the newly created table and referencing it through the trigger to the grant.
  Any suggestions? Thanks.</p>