MOUS16

On behalf of the Michigan Oracle User Summit (www.mous.us), I would like to personally thank all vendors, Speakers, attendee’s and volunteers for taking the time attend our annual technology conference. Your participation in the conference was the reason for the continued success of the conference and nearly 250 participants.

We have posted the presentations on our website (http://www.mous.us/presentations.html).  I would also like to extend an invitation to everyone for next year’s conference on Wednesday, November 8, 2017 – #MOUS17, (please visit our website for more information – www.mous.us or SEMOP) .   If you are interested please contact me mjgangler@gmail.com. We will be opening a call for papers in May.

Hope to see you at #MOUS17

–Mike

US Pro Rugby – premiers this weekend – AOL.com

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 AOL.com 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.

 

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

2016_1197_gangler_pdf

 

2016_1198_gangler_ppt

 

2016_1201_gangler_ppt

Oracle Open World Update and IOUG Select

First of all – Please download the latest version of the IOUG’s SELECT Journal – filled with great content about “ACFS” and “in-Memory Magic”  – the Link is 3rd Quarter IOUG Journal – #IOUG

Oracle Open World Happenings  – #OOW15

Also the IOUG  #IOUG will be hosting Special Interest Group (SIG) meetings on the following days int the User Group Pavillon – Meeting Room – Moscone South

Monday – October 26 – IOUG Cloud Computing SIG – 10 – 11am and IOUG EM12C SIG – 5 – 6pm – OTN LOUNGE

Tuesday – October 27 – IOUG IoT SIG – 10:30 – 11:30 and IOUG BIWA SIG – 11:30a – 12:30p

Wednesday – October 28th – IOUG Exadata SIG – 10:30 – 11:30, IOUG RAC SIG – 1 – 2p, and Oracle 12C SIG – 2 – 3pm

My Presentations:

Tuesday Lastly, i will be speaking on Tuesday – October 27 – Intercontinental C – 5 Floor – 5:15 – 6pm

CON2528 – Transforming Application Delivery with Private Cloud Appliance

Hope to see you there or at this years Open World

–Mike

mjgangler@gmail.com

oracleace2

 

 

MOUS15 (Michigan Oracle User Summit) – Call for Papers – Deadline 7/31/15

 

Presentations are still being accepted for the Michigan Oracle Users Summit 2015 (www.mous.us) on November 18th, 2015. As in the past, this year’s all day event will be held at Schoolcraft College VisTaTech Center in Livonia, Michigan. Its a Premier event with many Oracle Ace’s presenting and Rich Niemiec, President of Rolta and Past-President of the IOUG as our Keynote speaker and the deadline for presentations is July 31, 2015.   If you have any questions, please contact me – Mike Gangler at mjgangler@yahoo.com.   

Presentations are being accepted for the following focus areas:

  • Oracle Technology
  • Hyperion
  • E-Business Suite
  • JDEdwards
  • PeopleSoft
  • Business Intelligence
  • Business Management
  • Big Data
  • General

If you’re interested in submitting a topic for consideration for the upcoming Michigan Oracle User Summit on November 18th, 2015, we want to hear from you. To submit your topic(s) today by clicking here. 

All presenters receive FREE registration to the Summit – a $50 value!!!!

Registration will start soon. 

Granting Oracle Schema Permissions (Objects not created yet)

Recently we had a customer who wanted to have read only access to all tables in a schema, even tables not created yet. Apparently in Microsoft SQLServer, there is a way to grant a user schema permissions and includes objects not created yet.

Since i am unaware of a way to do this automagically in Oracle, i decided to create a “after ddl” trigger on the schema to grant the permissions when objects are created. The challenge is that pl/sql doesn’t allow running ddl permissions, i had to create a work around for the pl/sql and ddl challenges. The resolution was to use dbms.job_submit (Thanks “Ask Tom”) and submit a job to run the permissions.

Here is the code I used and please modify to suit your needs: (For this example i’m using IOUG as the application name/user)

#1 – Create a read only role first:

Create role IOUG_READONLY;

#2 – Grant read only role to the user (IOUG) requiring the permissions

grant IOUG_READONLY to IOUG;

#2 – Connect to application schema user (Owns objects) and create “after ddl” trigger (Sorry for the doublespace !)

CREATE or REPLACE TRIGGER AFTER_DDL AFTER DDL on IOUG_OBJECTS.SCHEMA
v_sysevent varchar2(25);
v_message varchar(255);
l_job number;
begin
select ora_sysevent into v_sysevent from dual;
if ( v_sysevent in ('CREATE') )
then
v_message := 'execute immediate "grant select on IOUG_OBJECTS.'||ora_dict_obj_name||' to IOUG_READONLY";';
dbms_job.submit (l_job,replace(v_message,'"','''') ) ;
end if;
end;
/

Now whenever a new object gets created the role is granted via the pl/sql and dbms_job.  The following is a test output:

Connect IOUG_OJBECTS/pw

IOUG_OBJECTS@IOUGDEV > create table foo1 (col1 varchar2(255));

Table created.

IOUG_OBJECTS@IOUGDEV > connect IOUG/pw

Connected.
IOUG@IOUGDEV > select * from IOUG_OBJECTS.foo1;

no rows selected

IOUG@IOUGDEV > desc IOUG_OBJECTS.foo1;
Name Null? Type
—————————————– ——– —————————-
COL1 VARCHAR2(255)

 

select * from IOUG_OJBECTS. OBJECT_NAME  *** NOTE – You must put the schema name before the table name (IOUG_OBJECTS), because the grants didn’t include the a public synonym.

 

Please let me know if this works for you and big thanks to “Ask Tom” who helped me resolve the PL/SQL and DDL issue.  Also, please let me know if there is a automagic way to do this Oracle.