| directory and create directory rights [message #118350] |
Wed, 04 May 2005 10:37  |
shooter
Messages: 44
Registered: February 2005
|
Member |
|
|
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?
Thanks
|
|
|
|
| Re: directory and create directory rights [message #118352 is a reply to message #118350] |
Wed, 04 May 2005 10:45  |
Frank Naude
Messages: 4587
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.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
