Cannot GRANT WRITE ON DIRECTORY EXTRACT_DIR TO [message #6763] |
Mon, 05 May 2003 12:43 |
LASCOLI
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
I can create the extract directory, but can't grant write privileges to a user. I can grant read, and I am logged in Oracle8i as sys. The directory on the file system is wide open as far as perms, and the user exists in both the Oracle8i and File System. I am using a Linux Box. Any suggestions are welcomed. Thanks
drwxrwxrwx 14 oracle oinstall 4096 May 5 10:46 oracle
CREATE OR REPLACE DIRECTORY EXTRACT_DIR AS' homeoracleextract'
SQL> GRANT WRITE ON DIRECTORY EXTRACT_DIR TO dbimpl
2 ;
GRANT WRITE ON DIRECTORY EXTRACT_DIR TO dbimpl
*
ERROR at line 1:
ORA-22928: invalid privilege on directories
|
|
|