| Not able to Grant Write Permission [message #43249] |
Sun, 29 June 2003 22:42  |
Suman Chattopadhyay
Messages: 9
Registered: June 2003
|
Junior Member |
|
|
Hi All,
I have created a directory C:DATA. Now from oracle I have mapped it as follows-
Create or replace directory emp_dir as 'C:DATA'.
I have granted READ permission on this directory(emp_dir) to scott. But while trying to give WRITE permission I am getting an error message saying-
"INVALID PRIVILEGE ON DIRECTORY"
Can any one explain me the reason and give me a remedy to this problem. My O.S is Windows 2000 advanced Server
Thanks In advance.
Suman
|
|
|
|
| Re: Not able to Grant Write Permission [message #43260 is a reply to message #43249] |
Mon, 30 June 2003 06:58  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
First please keep in mind that when you create an directory in Oracle it will be maping on the server and not on your local hard disk.
Further:
You can also check the parameter file:
look for the parameter: utl_file_dir for each directory you want to make accessible.
To bypass server security and allow read/write access to all directories, you can use this special syntax:
utl_file_dir = *
But that is dangerous. Any Body can then even
write on your datafile, control files and so on.
Vikas Gupta.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
