Re: ORA-24247: network access denied by access control list (ACL)

Posted by Roshan on Feb 24, 2017; 7:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-24247-network-access-denied-by-access-control-list-ACL-tp2203p2208.html

Hello,

thanks. Issue is solved. I created the ACL and I created a role(connect privilege) to which I assigned in the add privilege statement.

Then for all other users I granted that role.

BEGIN
  DBMS_NETWORK_ACL_ADMIN.DROP_ACL (
    acl         => 'adduserwsv.xml');
  COMMIT;
END;
/


SQL> select acl , principal , privilege , is_grant from DBA_NETWORK_ACL_PRIVILEGES;

BEGIN
   DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
    acl          => 'adduserwsv.xml',
    description  => 'APPS',
    principal    => 'CBS_CORE',
    is_grant     => TRUE,
    privilege    => 'connect');
   COMMIT;
END;
/

create role cbsrole;

BEGIN
   DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
    acl          => 'adduserwsv.xml',                
    principal    => 'CBSROLE',
    is_grant     => TRUE,
    privilege    => 'connect',
    position     => null);
   COMMIT;
END;
/


BEGIN
   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
    acl          => 'adduserwsv.xml',                
    host         => '10.210.228.8/*');
   COMMIT;
END;
/

Regards,

Roshan