title: for loop with dynamic table name and execute immediate
body: <p>in my Procedure there is the following code line</p>
  <pre><code>  for i in (select schema_name, table_name, restricted_columns
              from GRANTED_TABLES_FOR_ROLE
              where restricted_columns = 0) loop
      execute immediate 'grant select on ' || i.schema_name || '.' || i.table_name || ' to ROLE_NAME';
    end loop;
  </code></pre>
  <p>because i want to create the table &quot;GRANTED_TABLES_FOR_ROLE&quot; earlier in my procudere i can't create the procedure without the &quot;GRANTED_TABLES_FOR_ROLE&quot; existing.</p>
  <p>is there any way to make the code above dynamic so i can set a variable for the table &quot;GRANTED_TABLES_FOR_ROLE&quot;?</p>
  <p>how i can achieve this?</p>
  <p>thanks for your help!</p>