CODEWITHSUNDEEP
oracle-databaseoracle10g
Nipun
Nipun

Reputation: 1485

Granting "Create Directory" Privileges in Oracle

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?

Upvotes: 13

Views: 82052

Answers (2)

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

From the Oracle 10gR2 documentation:

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

As always with the privileges ANY, be careful who you will grant them to. It is indeed a powerful privilege best left to DBAs.

Upvotes: 19

dpbradley
dpbradley

Reputation: 11915

From Oracle docs:

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

So,

grant create any directory to userOfInterest;

Upvotes: 4

Related Questions