Alex Rivera | Logout

Granting "Create Directory" Privileges in Oracle

Asked 2009-06-29T14:50:13.977
13

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?

Edit
Report

1 Answer

4

From Oracle docs:

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

So,

grant create any directory to userOfInterest;

answered 2009-06-29T14:57:30.217

Your Answer