Home » RDBMS Server » Security » directory and create directory rights
directory and create directory rights [message #118350] Wed, 04 May 2005 10:37 Go to next message
Messages: 44
Registered: February 2005
I am working on Oracle 9i.

I need to create a directory, but the user I am using has not enough rights/privileges to create a directory.

What are the rights/privileges required to create a directory?

How can I give them to this particular user through Enterprise Manager or preferably through an SQL command?

Re: directory and create directory rights [message #118352 is a reply to message #118350] Wed, 04 May 2005 10:45 Go to previous message
Frank Naude
Messages: 4575
Registered: April 1998
Senior Member
You need the following privs:

CREATE ANY DIRECTORY - Create directory database objects
DROP ANY DIRECTORY - Drop directory database objects

However, don't be too surprised if you DBA don't want to grant them to you. With these privs you can do serious harm to a system (like reading password files, overwriting files, etc).

Best regards.

Previous Topic: table access query
Next Topic: create package/trigger privileges
Goto Forum:

Current Time: Mon Sep 25 19:01:53 CDT 2023