I want to run a CREATE DIRECTORY query in Oracle 10, but it's giving me an insufficient privileges error.
CREATE DIRECTORY
Can anybody tell me how to grant this privilege to my user through the system as a user?
From Oracle docs:
"You must have CREATE ANY DIRECTORY system privilege to create directories."
So,
grant create any directory to userOfInterest;