Home » RDBMS Server » Security » Not able to Grant Write Permission
Not able to Grant Write Permission [message #43249] Sun, 29 June 2003 22:42 Go to next message
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 Go to previous message
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.
Previous Topic: Oracle Audit Log Monitoring
Next Topic: system account got locked
Goto Forum:
  


Current Time: Sat Sep 25 11:09:42 CDT 2021