Database Security Products (MOSC)

MOSC Banner

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

edited Jun 4, 2012 1:52AM in Database Security Products (MOSC) 3 commentsAnswered
------- ACL
DECLARE  
  l_acl_name         VARCHAR2(30) := 'ftp_conn_test.xml';
  l_ftp_server_ip    VARCHAR2(20) := '134.239.239.3';
  l_ftp_server_name  VARCHAR2(20) := 'bsnet-test';
  l_username         VARCHAR2(30) := 'TEST';
BEGIN
  begin
     dbms_network_acl_admin.drop_acl(  'ftp_conn_test.xml'     );
  end;
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => l_acl_name,
    description  => 'Allow connections using UTL_TCP',
    principal    => l_username,
    is_grant     => TRUE,
    privilege    => 'connect',
    start_date   => null,
    end_date     => NULL);
  COMMIT;
  DBMS_NETWORK_ACL_ADMIN.add_privilege (
    acl         => l_acl_name,
    principal   => l_username,
    is_grant    => FALSE,
    privilege   => 'connect',
    position    => NULL,
    start_date  => NULL,
    end_date    => NULL);
  COMMIT;
  DBMS_NETWORK_ACL_ADMIN.assign_acl (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center