This discussion is archived
1 Reply Latest reply: Dec 31, 2012 4:46 AM by Harm Joris ten Napel RSS

Can we create ACL any where?

DBA Newbie
Currently Being Moderated

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 @


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.

  • 1. Re: Can we create ACL any where?
    Harm Joris ten Napel Pro
    Currently Being Moderated

    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


    Harm ten Napel

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points