Last active
January 23, 2016 05:36
-
-
Save arbo-hacker/58381b1f075aa8e6e8c7 to your computer and use it in GitHub Desktop.
Permitir invocar Web Services desde base de datos Oracle 11g
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
---######## 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