Scribd
Upload
126 views2 pages

Login Using Sys User: To Be Done by Oracle SYS

The document provides steps to configure access control lists (ACLs) for the utl_http package in Oracle. It involves granting execute permission on utl_http to a replication schema, dropping any existing ACL, creating a new ACL, assigning the ACL to an IP address and port, adding privileges to the ACL, and assigning the ACL globally.

Uploaded by

Abhishek Jha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
126 views2 pages

Login Using Sys User: To Be Done by Oracle SYS

The document provides steps to configure access control lists (ACLs) for the utl_http package in Oracle. It involves granting execute permission on utl_http to a replication schema, dropping any existing ACL, creating a new ACL, assigning the ACL to an IP address and port, adding privileges to the ACL, and assigning the ACL globally.

Uploaded by

Abhishek Jha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ACL CONFIGURATION (utl_http)

To be done by Oracle SYS

Login using sys user

GRANT EXECUTE ON utl_http TO <Replication-Schema>;

Then follow below steps.

1) Drop ACL if already exist.

begin

DBMS_NETWORK_ACL_ADMIN.drop_acl(acl => 'utl_http');

END;

2)  Create an access control list

BEGIN

dbms_network_acl_admin.create_acl(

acl => 'utl_http.xml',

description => 'Enable',

principal =>'AUTOMATION',

is_grant=> true,

privilege => 'connect');

commit;

end;

3) Assign ACL

begin

dbms_network_acl_admin.assign_acl (

acl=> 'utl_http.xml',
host=>'192.9.200.31',

lower_port=>'25');

commit;

end;

4) Add privilege

begin

DBMS_NETWORK_ACL_ADMIN.add_privilege (

acl =>'utl_http.xml',

principal =>'AUTOMATION',

is_grant=> TRUE,

privilege=> 'connect');

COMMIT;

end;

BEGIN

Dbms_Network_Acl_Admin.Assign_Acl (Acl => 'utl_http.xml',Host => '*');

END;

You might also like