如何为Oracle 11g添加ACL规则以允许PL/SQL上传文件 [英] How can a add acl rules for Oracle 11g to allow pl/sql upload file
本文介绍了如何为Oracle 11g添加ACL规则以允许PL/SQL上传文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在Oracle 11g中,数据库具有精细的网络访问控制列表,因此当我使用pl/sql将文件上传到ftp_server时,它给了我网络访问错误.
In Oracle 11g ,the database has an Fine-Grained network access control list, so when i use pl/sql to upload a file to the ftp_server,it gives me a network access error.
这样的错误信息:
error at 1 line:
ORA-29260: network error:not connected
ORA-06512: at "SYS.UTL_TCP", line 212
ORA-06512: at "SYS.UTL_TCP", line 432
ORA-06512: at "SCOTT.FTP", line 413
ORA-24247: Network access rejected by acl
ORA-06512: at "SCOTT.FTP", line 491
ORA-06512: at line 6
我想知道如何创建acl规则,以便获得特权. 谢谢
I want to know how can i do about creating acl rules so that i can get the privilege. Thanks
推荐答案
Here's a tutorial about ACL in Oracle.
这篇关于如何为Oracle 11g添加ACL规则以允许PL/SQL上传文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文