本文介绍了授予“创建目录" Oracle中的特权的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想在Oracle 10中运行一个CREATE DIRECTORY查询，但这给了我一个不足的特权错误.
I want to run a CREATE DIRECTORY query in Oracle 10, but it's giving me an insufficient privileges error.
有人可以告诉我如何以用户身份通过系统向我的用户授予此特权吗?
Can anybody tell me how to grant this privilege to my user through the system as a user?
推荐答案
来自 Oracle 10gR2文档:
您将使用以下命令向将创建目录的架构授予特权:
You would use the following command to grant the privilege to the schema that will create the directory:
SQL> GRANT CREATE ANY DIRECTORY TO vnz;
Grant succeeded
与特权ANY一样，请务必将其授予谁.确实，最好的特权留给了DBA.
As always with the privileges ANY, be careful who you will grant them to. It is indeed a powerful privilege best left to DBAs.
这篇关于授予“创建目录" Oracle中的特权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！