title: Grant Select on All VIEWS [current and future] in Schema X
body: <p>I have a situation in our Oracle environment where I would like to be able to grant select permissions to a certain user/group on all views in a particular schema. </p>
  
  <p>I realize that I could write a dynamic statement to iterate over all the views in the schema and grant permissions to them individually as shown <a href="https://forums.oracle.com/thread/842689" rel="nofollow">here</a> but I would like to be able to have this apply to all views that exist in the schema now or in the future. </p>
  
  <p>I was also contemplating the possibility of writing a <a href="http://psoug.org/reference/ddl_trigger.html" rel="nofollow">DDL trigger</a> that could monitor for the creation of new views but setting permissions in a trigger isn't something I've seen done before and doesn't seem like accepted practice.</p>
  
  <p>Basically, is there a <strong>VIEW</strong> analog to the <strong>GRANT EXECUTE ANY PROCEDURE</strong>?</p>