Tuesday, November 19, 2013

Setting up Network oracle ACLs in Oracle 11g

 Goal: how to add oracle ACL to database

with sys investigate:
 
select * from dba_network_acls;

select * from dba_network_acl_privileges;

select * from user_network_acl_privileges;


dependencies from users:

SELECT   owner,
         name,
         TYPE,
         referenced_name
  FROM   DBA_DEPENDENCIES
 WHERE   referenced_name IN ('UTL_TCP', 'UTL_SMTP', 'UTL_MAIL', 'UTL_HTTP', 'UTL_INADDR')
         AND owner NOT IN ('SYS', 'PUBLIC', 'ORDPLUGINS');


add my ACL to all of them:

DECLARE
  ACL_PATH  VARCHAR2(4000);
  CURSOR C1 IS
  SELECT distinct owner FROM DBA_DEPENDENCIES
  WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_INADDR')
  AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS');
BEGIN
  FOR R1 IN C1 LOOP
  BEGIN
  SELECT acl INTO acl_path FROM dba_network_acls
  WHERE host = 'host_name' AND lower_port IS NULL AND upper_port IS NULL;
        IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(acl_path,
                                         r1.owner,'connect') IS NULL THEN
               DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path,
                                         r1.owner, TRUE, 'connect');
        END IF;
  EXCEPTION
     WHEN no_data_found THEN
       DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('myACL.xml',
                                         'ACL for network packages',
                                         r1.owner,
                                         TRUE,
                                         'connect');
       DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('myACL.xml','host_name');
END;
COMMIT;
END LOOP;
END;
/

Friday, September 27, 2013

Wildcard conference 2013


Report about wildcard conference 2013 on behalf of the Latvian Oracle User Group (LVOUG)

Overview

Wildcard 2013 – A High-Level IT Conference „With Huge Ambition and Potential”  
On the 13th of September, about 300 IT brains from Latvia and abroad came to Jurmala in the framework of the first IT community-driven conference in Latvia – Wildcard 2013.
For one day Jurmala’s Baltic Beach SPA & Resort Hotel (Jurmala, Juras iela, 23/25) became the center of networking of Information Technology developers, who were involved in sessions, discussions and workshops, organized by Latvian IT user groups together with both local and international speakers.


Facts
Date:   2013.09.13
Place:   Jurmala, Latvia
Venue:  Baltic Beach Hotel
Organized by 3 Latvian user groups :
 Latvian Developers Network www.ldn.lv
 Agile Latvia www.agilelatvia.org
  Latvian Oracle User Group www.lvoug.lv

Attendees:
 241 registered attendees, ~230 actual
 34 speakers
 20 crew and orgs
 ~290 in total
Tracks:
 Engeneering
 Database
 Testing
 Web & Mobile
 Agile and Craftsmanship
 2 workshops tracks

Miscellanious:
 130 official photos http://www.beta.lv/wildcard
 Conference coverage: http://goo.gl/ydy01e