GLOC16 is here !!

This year there are more Oracle ACES presenting than ever before at the Great Lakes Oracle Users Conference. Check out the Schedule at a Glance and see which sessions you want to attend. Oracle Aces include Susan Behn, Karen Brownfield, Michael Gangler, Gustavo Gonzalez, Tim Gorman, Janis Griffin, Kyle Hailey, Francis Mignault, Daniel Morgan, Rich Niemiec, Kerry Osborne, Elke Phelps, Tanel Poder, Kellyn Pot’Vin-Gorman, Carlos Sierra, Scott Spendolini, Deanna Sunde, Mark Bobak, Ric Van Dyke, and Tim Vlamis.

I will be speaking on May 19th from 4 – 5:00pm on “Using RPM’s to distribute OEM Agents”

TO Register:



US Pro Rugby – premiers this weekend –

Saturdays game was good to see, closest team for us in Midwest is Ohio…  

After an exciting opening week, PRO Rugby continues its debut season when Denver looks to win its second straight while taking on San Francisco. The much-anticipated showdown will be streamed live on Sunday at 6 p.m. ET.

Fans can also enjoy a replay of Saturday’s game between San Diego and Sacramento.

PRO Rugby — the first team-sport professional league to launch in the United States since Major League Soccer in 1993 and Major League Lacrosse in 2001 — officially kicked off last Sunday, as Denver got by Ohio, 19-13, in overtime and Sacramento edged San Francisco 37-25 in a rivalry match.

For full rosters of each team, CLICK HERE.


Granting Oracle Schema Permissions (Objects not created yet) – Part 2

After presenting at Collaborate 16 about granting schema permissions, a colleague – Frank Pound send me the following that can also be used to perform the trigger only on “Tables”:

create or replace trigger trigger_grant_dml

after create on schema
v_job number;
v_todo varchar2(200);
     if ora_sysevent = 'CREATE' and ora_dict_obj_type = 'TABLE' then
     v_todo:='execute immediate ''grant select, insert, update, delete on '||ora_dict_obj_name||' to my_new_role'';';
     dbms_job.submit(job=>v_job, what=>v_todo);
  end if;
  when others then


Please contact me with any questions -

Collaborate 16 !

I will be presenting 3 presentations at this years Collaborate 16 in Las Vegas.

Monday – April 11 – 12 – 12:30 – Palm B – Using Puppet and RPM’s to deploy EM12C Agents

Wednesday – April 13 – – 12:00 – 12:30 – Jasmine B – Granting Oracle Schema Permissions When Objects not Created Yet !

Thursday – April 14 – 8:30 am – 9:30 am – Palm  D – Optimize and Simplify Oracle 12C RAC using dNFS, ZFS and OISP