授予“创建目录" Oracle中的特权 [英] Granting "Create Directory" Privileges in 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?

推荐答案

来自

您必须具有CREATE ANY DIRECTORY系统特权才能创建目录.

You must have CREATE ANY DIRECTORY system privilege to create directories.

您将使用以下命令向将创建目录的架构授予特权:

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中的特权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！