1 Reply Latest reply: Dec 31, 2012 6:46 AM by Harm Joris ten Napel-Oracle RSS

    Can we create ACL any where?

    DBA
      Hi,

      as a part of my DB migration, i was asked to create the ACLS in the target DB and i am completely new to ACLS. Can any body guide me following points.

      1) can i create ACLS in any location. for eg. in my source database. ACL related file is located @

      /sys/acls/network_services.xml

      but in my TARGET DB can i create in any other location?

      for eg in ORACLE_HOME location.

      2) How this will be managed in RAC(Active/passive) environment?

      Thanks in-advance.

      Regards
      DBA.
        • 1. Re: Can we create ACL any where?
          Harm Joris ten Napel-Oracle
          Hi,

          1) no you can't , the path /sys/acls is inside the database and not on the filesystem, when you configure an acl using
          dbms_network_acl_admin, only refer to the xml filename without the path and the database will take care of properly
          storing the xml file in the XDB repository,

          2) since it's inside the db and not the filesystem there's no issue with RAC

          greetings,

          Harm ten Napel

          Edited by: hnapel on Dec 31, 2012 4:46 AM