如何为Oracle 11g添加ACL规则以允许PL/SQL上传文件 [英] How can a add acl rules for Oracle 11g to allow pl/sql upload file

问题描述

在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屋！