1 Reply Latest reply: Nov 27, 2010 6:46 AM by ora_tech RSS

    Network ACLs topics after upgrade to 11g.

    748245
      Hi Group

      On my pre script upgrade from 10.2.0.4 to 11.1.0.7, a message appear on the final part of the log:

      WARNING: --> Database contains schemas with objects dependent on network
      packages.
      .... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
      .... USER USR_COMP has dependent objects.
      .... USER USR_DEV has dependent objects.

      Really I don't know what to do on this issue.

      I've read the instructions and I have executed the following but I'm not sure it be right procedure:

      BEGIN

      DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('netacl.xml',
      'Allow usage to the UTL network packages', 'USR_COMP', TRUE, 'connect');
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('netacl.xml' ,'USR_COMP', TRUE, 'resolve');
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('netacl.xml' ,'USR_DEV', TRUE, 'connect');
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('netacl.xml' ,'USR_DEV', TRUE, 'resolve');

      -- Specify which hosts this ACL applies to,
      -- for simplicity, we're saying all (*)
      -- You might want to specify certain hosts to lock this down.
      DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('netacl.xml','*');
      END;
      /

      How can I validate that both users now have the correct privileges from the old version?

      Thanks in advance