ACLPrivileges for websites
FIND ACL PRIVILEGES
====================
set pages 1000 lines 1000
col acl for a50
col principal for a20
col privilege for a20
col is_grant for a20
col invert for a20
col acl_owner for a5
select ACL,principal,privilege,is_grant,invert,acl_owner from DBA_NETWORK_ACL_PRIVILEGES;
set pages 1000 lines 1000
col host for a40
col lower_port for a10
col upper_port for a10
col acl for a50
col acl_owner for a30
select host,lower_port,upper_port,acl,acl_owner from dba_network_acls;
ACL PRIVILEGE FOR WEBSITES
============================
col host for a40
col lower_port for a10
col upper_port for a10
col acl for a50
col acl_owner for a30
select host,lower_port,upper_port,acl,acl_owner from dba_network_acls;
ACL PRIVILEGE FOR WEBSITES
============================
CONN / AS SYSDBA
begin
dbms_network_acl_admin.create_acl (
acl => ‘utl_http1112.xml’,
description => ‘HTTP Access’,
principal => ‘schema_name‘,
is_grant => TRUE,
privilege => ‘connect’,
start_date => null,
end_date => null
);
dbms_network_acl_admin.add_privilege (
acl => ‘utl_http1112.xml’,
principal => ‘schema_name‘,
is_grant => TRUE,
privilege => ‘resolve’,
start_date => null,
end_date => null
);
dbms_network_acl_admin.assign_acl (
acl => ‘utl_http1112.xml’,
host => ‘*’,
lower_port => 8080,
upper_port => 8080
);
commit;
end;
/