title: auditing all tables in a schema
body: <p>I was wondering if there is a way (in Oracle(11g)) to audit all of the tables in a given schema. I have a lot of tables that need to be audited and don't want to have to manually audit each individual tables. Would a cursor be appropriate in this situation? Any advice would be greatly appreciated. Cheers!</p>
  
  <p>Here is the simple cursor I thought might work..</p>
  
  <pre><code>cursor table_names is
  SELECT owner, table_name
    FROM all_tables
    where owner like 'MYSCHEMA%';
    begin 
  
    for x in table_names
    loop 
    audit_all := 'audit all on table_name';
  
    end loop;
  
    end;
  </code></pre>