Home » RDBMS Server » Security » Cannot GRANT WRITE ON DIRECTORY EXTRACT_DIR TO
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
Previous Topic: DBMS_OBFUSCATION_TOOLKIT Question
Next Topic: Role problem !! Help.
Goto Forum:
  


Current Time: Mon Sep 27 08:19:38 CDT 2021