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 ) ![]() 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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |