Home » SQL & PL/SQL » SQL & PL/SQL » Not being able to grant write permissions
Not being able to grant write permissions [message #7598] Tue, 24 June 2003 06:00 Go to next message
Suman Chattopadhyay
Messages: 9
Registered: June 2003
Junior Member
I have created a directory c:data.In Sql prompt I have mapped it as follows---

Create directory emp_dir as c:data
I have granted read permission to scott on emp_dir.But while giving write permission to scott it is giving an error message "Invalid Priviledge". I am having windows2000 advanced server as O.S.
Please suggest me an way out.

Suman
Re: Not being able to grant write permissions [message #7601 is a reply to message #7598] Tue, 24 June 2003 10:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the directory name 'c:data '
should be in upper case like C:DATA.

Create the directory,
grant read persmission
and try again

Previous Topic: SQL*PLUS '&' functionality
Next Topic: help with select statement
Goto Forum:
  


Current Time: Thu Mar 28 11:19:45 CDT 2024