Or IP address for from the database is restricted by an access control list (ACL). Requires XML DB to be installed in order to use those packages.Įach external host that a database user wants to connect to or to resolve the name Implemented by XML DB's access control list (ACL) mechanism and, therefore, Raises an exception if the invoker lacks the privileges. Invoker for the necessary privileges only when the calls are made at runtime and Host or to resolve the name or the IP address of a host.
The invoker of those packages needs additional privileges to connect to an external PL/SQL packages: UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, and UTL_INADDR. UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, and UTL_INADDR PL/SQL PackagesĪ new security measure is introduced in this release for the following network-related 'ACL description', 'user_name', TRUE, 'connect' ) ĭBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( 'ACL_name.xml', 'host_name' ) NETWORK_ACL_ADMIN.CREATE_ACL ( 'ACL_name.xml', IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE (acl_path,ĭBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (acl_path, SELECT acl INTO acl_path FROM dba_network_acls If no ACL exists for host_name, then the example creates a new ACL called ACL_name, grants the CONNECT privilege to user_name, and assigns the ACL to host_name. If one is found, then the example grants user_name the CONNECT privilege in the ACL only if that user does not already have it. The following example first looks for any ACL currently assigned to host_name.
You must also configure network access control lists (ACLs) in the database before these packages can work as they did in prior releases. If you have applications that use one of these packages, you must install Oracle XML DB if it is not already installed. Oracle Database 11g Release 1 (11.1) includes fine-grained access control to the UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, or UTL_INADDR packages using Oracle XML DB.
SQL> exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('MY.xml','*.abc.com') Ĭonfigure Fine-Grained Access to External Network Services
SQL> exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('MY.xml', If above query not show XML DB component then run following sql to install XML DBįollowing example show, how add scott user to ACL SQL> select COMP_NAME, status from dba_registry You need execute addition steps and add user to ACL ( access control list )
#How To Install Dbms_Network_Acl_Admin Package code
Virag Sharma your application code ( package, procedure, function ) uses utl_tcp, utl_smtp etc and you upgraded database to oracle 11g, then that code will not work even you gave execute permission on utl_tcp etc to user
0 kommentar(er)
