Skip to content

Instantly share code, notes, and snippets.

@arbo-hacker
Last active January 23, 2016 05:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arbo-hacker/58381b1f075aa8e6e8c7 to your computer and use it in GitHub Desktop.
Save arbo-hacker/58381b1f075aa8e6e8c7 to your computer and use it in GitHub Desktop.
Permitir invocar Web Services desde base de datos Oracle 11g
---######## Este script crea el ACL en la BD:
begin
dbms_network_acl_admin.create_acl (
acl             => 'nombreacl.xml',
description     => 'Normal Access',
principal       => 'CONNECT',
is_grant        => TRUE,
privilege       => 'connect',
start_date      => null,
end_date        => null
);
end;
/
---######## Este script autoriza al usuario específico poder usar el ACL creado anteriormente:
begin
dbms_network_acl_admin.add_privilege (
acl           => 'nombreacl.xml',
principal     => 'oe', -- usuario de base de datos
is_grant      => TRUE,
privilege     => 'connect',
start_date    => null,
end_date      => null);
end;
/
---#### Este script asocia un host al acl
begin
dbms_network_acl_admin.assign_acl (
acl => 'nombreacl.xml',
host => 'www.google.com', -- host
lower_port => 1,
upper_port => 10000);
end;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment